trees
47 rows where Fire Prevention Districts = 10 and qSpecies_id = 47 sorted by Location
This data as json, CSV (advanced)
qSiteInfo ✖
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9451 | 84120 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | 10 | 7 | 8 | 309 | 39 | |||
4229 | 80358 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6011201.39619 | 2088230.44969 | 37.7145146953757 | -122.403164591892 | (37.7145146953757, -122.403164591892) | 10 | 7 | 8 | 309 | 39 | |||
75050 | 49654 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 81 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | Permit Number 46507 | 6011171.19956943 | 2088331.01703059 | 37.7147891465513 | -122.403276034448 | (37.7147891465513, -122.403276034448) | 10 | 7 | 8 | 309 | 39 | ||
66800 | 49718 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1195 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663 | 37.7208461876659 | -122.391232442758 | (37.7208461876659, -122.391232442758) | 10 | 3 | 8 | 58 | 1 | |||
77789 | 201278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 28 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | 10 | 3 | 8 | 58 | 1 | |||
76430 | 30765 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1593 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34646 | 6014616.43299999 | 2093667.83534348 | 37.7296348056211 | -122.391740711397 | (37.7296348056211, -122.391740711397) | 10 | 3 | 8 | 58 | 1 | ||
148288 | 30756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.7297880302088 | -122.390362726863 | (37.7297880302088, -122.390362726863) | 10 | 3 | 8 | 58 | 1 | |
31750 | 200604 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 61 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016455.981 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | 10 | 3 | 8 | 58 | 1 | |||
125224 | 200619 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 60 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.7336283611401 | -122.385490033201 | (37.7336283611401, -122.385490033201) | 10 | 3 | 8 | 58 | 1 | |||
27885 | 200618 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 59 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.385517359434 | (37.733637339432, -122.385517359434) | 10 | 3 | 8 | 58 | 1 | |||
113599 | 200616 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 57 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | 10 | 3 | 8 | 58 | 1 | |||
79037 | 200614 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 55 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.7336998293082 | -122.385562980445 | (37.7336998293082, -122.385562980445) | 10 | 3 | 8 | 58 | 1 | |||
102287 | 200612 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 53 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016428.559 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | 10 | 3 | 8 | 58 | 1 | |||
104777 | 47604 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | 10 | 7 | 7 | 28859 | 2 | ||
32588 | 63441 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 299 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 24028 | 6008993.82853707 | 2096920.83270323 | 37.738253113659 | -122.411408443517 | (37.738253113659, -122.411408443517) | 10 | 7 | 7 | 28859 | 2 | ||
36450 | 247870 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 6009721.06953 | 2098395.0417 | 37.7423417348977 | -122.408997980481 | (37.7423417348977, -122.408997980481) | 10 | 7 | 7 | 28859 | 2 | ||||
80406 | 247869 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | 10 | 7 | 7 | 28859 | 2 | ||||
154236 | 247871 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6009746.3542 | 2098404.30325 | 37.7423685814537 | -122.408911206692 | (37.7423685814537, -122.408911206692) | 10 | 7 | 7 | 28859 | 2 | ||||
15284 | 191371 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 66 | Median : Yard | Tree | DPW 1 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.399636654017 | (37.7547181653131, -122.399636654017) | 10 | 3 | 8 | 28856 | 29 | ||||
6812 | 191370 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 63 | Median : Yard | Tree | DPW 1 | 15 | 6012517.15762 | 2102887.31193 | 37.7548327767283 | -122.399645237162 | (37.7548327767283, -122.399645237162) | 10 | 3 | 8 | 28856 | 29 | ||||
37104 | 191369 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 62 | Median : Yard | Tree | DPW 1 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | 10 | 3 | 8 | 28856 | 29 | ||||
95937 | 191368 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 60 | Median : Yard | Tree | DPW 1 | 25 | 6012502.16132 | 2102909.31056 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | 10 | 3 | 8 | 28856 | 29 | ||||
163899 | 191389 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.7581491445771 | -122.403906816767 | (37.7581491445771, -122.403906816767) | 10 | 3 | 8 | 28856 | 29 | |||
54525 | 191388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | 10 | 3 | 8 | 28856 | 29 | |||
179733 | 191387 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6011279.1597 | 2104155.21456 | 37.7582450689735 | -122.404015822688 | (37.7582450689735, -122.404015822688) | 10 | 3 | 8 | 28856 | 29 | |||
182337 | 191386 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6011275.59142 | 2104157.94605 | 37.7582523696726 | -122.404028355649 | (37.7582523696726, -122.404028355649) | 10 | 3 | 8 | 28856 | 29 | |||
133496 | 191385 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | 10 | 3 | 8 | 28856 | 29 | |||
105958 | 191384 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | 10 | 3 | 8 | 28856 | 29 | |||
123019 | 191383 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | 10 | 3 | 8 | 28856 | 29 | |||
181108 | 191382 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011269.01089 | 2104184.59965 | 37.7583251868659 | -122.404052989848 | (37.7583251868659, -122.404052989848) | 10 | 3 | 8 | 28856 | 29 | |||
167360 | 191381 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011271.17001 | 2104191.36243 | 37.7583438765916 | -122.404045998546 | (37.7583438765916, -122.404045998546) | 10 | 3 | 8 | 28856 | 29 | |||
122548 | 191380 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011289.9844 | 2104226.04846 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | 10 | 3 | 8 | 28856 | 29 | ||||
112785 | 191378 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011285.84337 | 2104240.29901 | 37.7584790653842 | -122.40399869511 | (37.7584790653842, -122.40399869511) | 10 | 3 | 8 | 28856 | 29 | ||||
113543 | 191379 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011295.70989 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | 10 | 3 | 8 | 28856 | 29 | ||||
98199 | 191377 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6011285.82751 | 2104250.98235 | 37.7585083985743 | -122.403999501776 | (37.7585083985743, -122.403999501776) | 10 | 3 | 8 | 28856 | 29 | ||||
69496 | 191376 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011285.44743 | 2104312.53247 | 37.7586773802801 | -122.404005147727 | (37.7586773802801, -122.404005147727) | 10 | 3 | 8 | 28856 | 29 | ||||
192536 | 191375 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6011300.32576 | 2104333.131 | 37.7587347705187 | -122.403955140934 | (37.7587347705187, -122.403955140934) | 10 | 3 | 8 | 28856 | 29 | ||||
165316 | 191374 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011292.66605 | 2104334.91271 | 37.7587392347502 | -122.403981757255 | (37.7587392347502, -122.403981757255) | 10 | 3 | 8 | 28856 | 29 | ||||
95984 | 191373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011285.49599 | 2104337.84522 | 37.7587468861739 | -122.40400676112 | (37.7587468861739, -122.40400676112) | 10 | 3 | 8 | 28856 | 29 | ||||
24972 | 191392 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011311.05886 | 2104374.20224 | 37.7588481426559 | -122.403920910926 | (37.7588481426559, -122.403920910926) | 10 | 3 | 8 | 28856 | 29 | ||||
46709 | 191390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | 10 | 3 | 8 | 28856 | 29 | ||||
55583 | 191391 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.403937978273 | (37.7588597960547, -122.403937978273) | 10 | 3 | 8 | 28856 | 29 | ||||
45957 | 191393 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011318.33835 | 2104379.19174 | 37.758862249405 | -122.403896086039 | (37.758862249405, -122.403896086039) | 10 | 3 | 8 | 28856 | 29 | ||||
63156 | 191394 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011327.58138 | 2104381.4608 | 37.7588689961229 | -122.403864278838 | (37.7588689961229, -122.403864278838) | 10 | 3 | 8 | 28856 | 29 | ||||
36662 | 121603 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | 10 | 3 | 8 | 28856 | 29 | |||
28693 | 191372 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011446.77315 | 2104664.66226 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | 10 | 3 | 8 | 28856 | 29 | |||
108342 | 35388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.15832 | 2104840.46729 | 37.7601281288176 | -122.403970671318 | (37.7601281288176, -122.403970671318) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );