trees
3,247 rows where qSpecies_id = 22 sorted by Longitude
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
140123 | 6595 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016681.72094 | 2097824.21819 | 37.7411618315488 | -122.384890173648 | (37.7411618315488, -122.384890173648) | 10 | 3 | 8 | 58 | 1 | ||
147488 | 6596 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 6 | 3X3 | 6016665.24254 | 2097836.86612 | 37.7411956487572 | -122.384948031546 | (37.7411956487572, -122.384948031546) | 10 | 3 | 8 | 58 | 1 | ||
40009 | 16528 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
107263 | 16534 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2004 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
142998 | 16530 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
170833 | 16535 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
3819 | 6627 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.7409882686849 | -122.385142357926 | (37.7409882686849, -122.385142357926) | 10 | 3 | 8 | 58 | 1 | ||
176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
146898 | 6625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | 10 | 3 | 8 | 58 | 1 | ||
9979 | 6601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.385305868181 | (37.7413960662634, -122.385305868181) | 10 | 3 | 8 | 58 | 1 | ||
48351 | 6624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/04/2004 12:00:00 AM | 3 | 3x3 | 6016547.14534 | 2097807.00624 | 37.7411071266849 | -122.385354293091 | (37.7411071266849, -122.385354293091) | 10 | 3 | 8 | 58 | 1 | ||
126967 | 6602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1997 12:00:00 AM | 6 | 3X3 | 6016545.70943 | 2097925.30543 | 37.7414318727766 | -122.385367499637 | (37.7414318727766, -122.385367499637) | 10 | 3 | 8 | 58 | 1 | ||
168314 | 6623 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016531.01979 | 2097819.10411 | 37.7411394528345 | -122.385410892796 | (37.7411394528345, -122.385410892796) | 10 | 3 | 8 | 58 | 1 | |||
149014 | 6603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1997 12:00:00 AM | 6 | 3X3 | 6016522.05024 | 2097942.62587 | 37.7414781222237 | -122.385450512434 | (37.7414781222237, -122.385450512434) | 10 | 3 | 8 | 58 | 1 | ||
185585 | 190448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6016474.94651 | 2097978.89323 | 37.7415750988015 | -122.385615909472 | (37.7415750988015, -122.385615909472) | 10 | 3 | 8 | 58 | 1 | |||
103780 | 190449 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 3 | : | Tree | Private 2 | 2 | Width 4ft | 6016446.96027 | 2097998.11216 | 37.7416263215051 | -122.385714016492 | (37.7416263215051, -122.385714016492) | 10 | 3 | 8 | 58 | 1 | |||
74794 | 6644 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:34:00 PM | 3 | 3X3 | 6016429.20834 | 2097898.03083 | 37.7413505362372 | -122.385768423283 | (37.7413505362372, -122.385768423283) | 10 | 3 | 8 | 58 | 1 | ||
168466 | 6634 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1495 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 08:44:00 AM | 3 | 3X3 | 6016398.96858 | 2097918.11995 | 37.7414040234725 | -122.385874382714 | (37.7414040234725, -122.385874382714) | 10 | 3 | 8 | 58 | 1 | ||
108663 | 6633 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1495 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1997 12:00:00 AM | 1 | 3X3 | 6016378.18563 | 2097933.75245 | 37.7414457969989 | -122.385947333025 | (37.7414457969989, -122.385947333025) | 10 | 3 | 8 | 58 | 1 | ||
27161 | 190450 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6016372.9615 | 2098053.57634 | 37.7417745198736 | -122.385973747016 | (37.7417745198736, -122.385973747016) | 10 | 3 | 8 | 58 | 1 | |||
12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
33442 | 6641 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6016333.53222 | 2097965.26149 | 37.7415298431186 | -122.386103926557 | (37.7415298431186, -122.386103926557) | 10 | 3 | 8 | 58 | 1 | |||
135121 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1499@Newhall Evans Ave | 2 | Front Yard : | Tree | Private 2 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.27381 | 37.7417009175609 | -122.386401389915 | (37.7417009175609, -122.386401389915) | 10 | 3 | 8 | 58 | 1 | ||
4481 | 83152 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6016214.02655 | 2098054.96896 | 37.741769546638 | -122.386523393735 | (37.741769546638, -122.386523393735) | 10 | 3 | 8 | 58 | 1 | ||
33616 | 190566 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016411.49198 | 2107989.98551 | 37.7690599417774 | -122.386533201771 | (37.7690599417774, -122.386533201771) | 14 | 3 | 9 | 310 | 20 | |||
6398 | 82303 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016177.26617 | 2098207.30464 | 37.7421857942275 | -122.386661120412 | (37.7421857942275, -122.386661120412) | 10 | 3 | 8 | 58 | 1 | |||
62476 | 6654 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016161.31179 | 2098218.85559 | 37.7422166274898 | -122.386717091517 | (37.7422166274898, -122.386717091517) | 10 | 3 | 8 | 58 | 1 | ||
188025 | 190567 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016343.36637 | 2107984.47117 | 37.7690410290422 | -122.386768461707 | (37.7690410290422, -122.386768461707) | 14 | 3 | 9 | 310 | 20 | |||
158482 | 6655 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016144.11034 | 2098231.69923 | 37.7422509411428 | -122.38677746482 | (37.7422509411428, -122.38677746482) | 10 | 3 | 8 | 58 | 1 | ||
131031 | 6656 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6016128.17059 | 2098243.97439 | 37.7422837636921 | -122.38683343593 | (37.7422837636921, -122.38683343593) | 10 | 3 | 8 | 58 | 1 | ||
87806 | 190568 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016318.75266 | 2107983.43695 | 37.7690368265244 | -122.386853527668 | (37.7690368265244, -122.386853527668) | 14 | 3 | 9 | 310 | 20 | |||
64367 | 6657 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016109.87489 | 2098256.65899 | 37.742317580006 | -122.386897581869 | (37.742317580006, -122.386897581869) | 10 | 3 | 8 | 58 | 1 | ||
149034 | 190569 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016293.39232 | 2107983.12919 | 37.7690345773055 | -122.386941226862 | (37.7690345773055, -122.386941226862) | 14 | 3 | 9 | 310 | 20 | |||
132681 | 6658 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6016095.55691 | 2098268.17698 | 37.7423484132627 | -122.386947892648 | (37.7423484132627, -122.386947892648) | 10 | 3 | 8 | 58 | 1 | ||
161608 | 192466 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1201 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016180.64466 | 2103115.54543 | 37.7556629912817 | -122.386991684241 | (37.7556629912817, -122.386991684241) | 10 | 3 | 8 | 28856 | 29 | |||
161969 | 6659 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 3 | 3X3 | 6016081.5878 | 2098278.96345 | 37.7423772572113 | -122.386996946162 | (37.7423772572113, -122.386996946162) | 10 | 3 | 8 | 58 | 1 | ||
151776 | 190453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501 Evans Ave | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6016075.66534 | 2098156.64839 | 37.7420410771473 | -122.387008895444 | (37.7420410771473, -122.387008895444) | 10 | 3 | 8 | 58 | 1 | |||
106158 | 190570 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016269.16007 | 2107982.62643 | 37.7690318550592 | -122.387025010418 | (37.7690318550592, -122.387025010418) | 14 | 3 | 9 | 310 | 20 | |||
78903 | 192467 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1101 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016155.45922 | 2103570.72934 | 37.7569114355414 | -122.387110531425 | (37.7569114355414, -122.387110531425) | 10 | 3 | 8 | 28856 | 29 | |||
52917 | 190571 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016244.2177 | 2107979.82534 | 37.7690227827156 | -122.387111089925 | (37.7690227827156, -122.387111089925) | 14 | 3 | 9 | 310 | 20 | |||
136972 | 6660 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016043.95648 | 2098306.88974 | 37.7424518532839 | -122.38712901249 | (37.7424518532839, -122.38712901249) | 10 | 3 | 8 | 58 | 1 | ||
79454 | 6661 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6016028.90772 | 2098318.24105 | 37.7424821883031 | -122.387181838675 | (37.7424821883031, -122.387181838675) | 10 | 3 | 8 | 58 | 1 | ||
173086 | 190452 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501 Evans Ave | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6016023.90854 | 2098196.63219 | 37.7421479984362 | -122.387190643943 | (37.7421479984362, -122.387190643943) | 10 | 3 | 8 | 58 | 1 | |||
131451 | 190572 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016218.95037 | 2107977.36129 | 37.7690146177521 | -122.387198316949 | (37.7690146177521, -122.387198316949) | 14 | 3 | 9 | 310 | 20 | |||
189175 | 6662 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.05161 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | 10 | 3 | 8 | 58 | 1 | ||
99126 | 190573 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016194.38649 | 2107976.86529 | 37.7690118955188 | -122.387283248044 | (37.7690118955188, -122.387283248044) | 14 | 3 | 9 | 310 | 20 | |||
69175 | 6663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1997 12:00:00 AM | 6 | 3X3 | 6015993.25804 | 2098345.22183 | 37.7425542977365 | -122.387306987444 | (37.7425542977365, -122.387306987444) | 10 | 3 | 8 | 58 | 1 | ||
137038 | 6653 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6015990.464364 | 2098347.4229363 | 37.7425601868054 | -122.38731680075 | (37.7425601868054, -122.38731680075) | 10 | 3 | 8 | 58 | 1 | ||
72771 | 6664 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1997 12:00:00 AM | 6 | 3X3 | 6015978.92164 | 2098355.83465 | 37.7425826443858 | -122.387357299115 | (37.7425826443858, -122.387357299115) | 10 | 3 | 8 | 58 | 1 | ||
91593 | 190574 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016169.13913 | 2107975.39199 | 37.769006451918 | -122.387370475084 | (37.769006451918, -122.387370475084) | 14 | 3 | 9 | 310 | 20 | |||
37993 | 6679 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1555X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 3 | 3X3 | 6015913.3615039 | 2098275.7507256 | 37.7423591192364 | -122.387578402998 | (37.7423591192364, -122.387578402998) | 10 | 3 | 8 | 58 | 1 | ||
94639 | 6677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1555X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6015913.3615039 | 2098275.7507256 | 37.7423591192364 | -122.387578402998 | (37.7423591192364, -122.387578402998) | 10 | 3 | 8 | 58 | 1 | ||
121676 | 96002 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1440 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015789.5338 | 2093564.664 | 37.7294165684422 | -122.387677946908 | (37.7294165684422, -122.387677946908) | 10 | 3 | 8 | 58 | 1 |
190503 | 96003 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1440 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015764.7456 | 2093584.4946 | 37.7294696462115 | -122.387765025927 | (37.7294696462115, -122.387765025927) | 10 | 3 | 8 | 58 | 1 |
144135 | 190575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016046.53772 | 2107968.65243 | 37.7689811557707 | -122.387794079147 | (37.7689811557707, -122.387794079147) | 14 | 3 | 9 | 310 | 20 | |||
149423 | 199873 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1446 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015749.8727 | 2093598.2658 | 37.7295066352884 | -122.387817403955 | (37.7295066352884, -122.387817403955) | 10 | 3 | 8 | 58 | 1 | |||
99223 | 190576 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016023.93976 | 2107967.06556 | 37.7689755467242 | -122.387872134002 | (37.7689755467242, -122.387872134002) | 14 | 3 | 9 | 310 | 20 | |||
64896 | 190577 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016001.60495 | 2107966.29221 | 37.7689721859532 | -122.387949335392 | (37.7689721859532, -122.387949335392) | 14 | 3 | 9 | 310 | 20 | |||
77023 | 190578 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015978.37212 | 2107965.30085 | 37.7689681767714 | -122.388029627781 | (37.7689681767714, -122.388029627781) | 14 | 3 | 9 | 310 | 20 | |||
170688 | 190579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015952.68728 | 2107963.87261 | 37.7689628321048 | -122.388118371088 | (37.7689628321048, -122.388118371088) | 14 | 3 | 9 | 310 | 20 | |||
167912 | 114550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015870.34934 | 2106264.23944 | 37.764291445828 | -122.388284537902 | (37.764291445828, -122.388284537902) | 14 | 3 | 8 | 28856 | 29 | ||
133722 | 114549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015846.45477 | 2106262.10927 | 37.7642842728198 | -122.388367034517 | (37.7642842728198, -122.388367034517) | 14 | 3 | 8 | 28856 | 29 | ||
57101 | 190580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015878.80294 | 2107959.2807 | 37.7689461298947 | -122.388373613948 | (37.7689461298947, -122.388373613948) | 14 | 3 | 9 | 310 | 20 | |||
158146 | 114548 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015820.59236 | 2106259.92484 | 37.7642768417202 | -122.38845633359 | (37.7642768417202, -122.38845633359) | 14 | 3 | 8 | 28856 | 29 | ||
155015 | 190581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015854.60324 | 2107958.79566 | 37.7689434570894 | -122.388457286 | (37.7689434570894, -122.388457286) | 14 | 3 | 9 | 310 | 20 | |||
102297 | 190582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015829.41164 | 2107957.60094 | 37.7689387806299 | -122.38854433945 | (37.7689387806299, -122.38854433945) | 14 | 3 | 9 | 310 | 20 | |||
99749 | 190583 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015780.1959 | 2107952.51143 | 37.7689220784184 | -122.388714219602 | (37.7689220784184, -122.388714219602) | 14 | 3 | 9 | 310 | 20 | |||
191479 | 190584 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015754.04725 | 2107952.30918 | 37.7689200738306 | -122.388804652706 | (37.7689200738306, -122.388804652706) | 14 | 3 | 9 | 310 | 20 | |||
134248 | 192465 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 797 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015653.23524 | 2103918.43414 | 37.7578383352893 | -122.388871698996 | (37.7578383352893, -122.388871698996) | 10 | 3 | 8 | 28856 | 29 | |||
101475 | 190510 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6015824.26654 | 2113066.39708 | 37.7829661172445 | -122.388918858534 | (37.7829661172445, -122.388918858534) | 6 | 2 | 9 | 28856 | 6 | |||
13942 | 192464 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 797 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015635.55835 | 2103917.93744 | 37.7578359916633 | -122.388932798913 | (37.7578359916633, -122.388932798913) | 10 | 3 | 8 | 28856 | 29 | |||
186662 | 190511 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015813.14404 | 2113067.73193 | 37.7829691659357 | -122.388957431354 | (37.7829691659357, -122.388957431354) | 6 | 2 | 9 | 28856 | 6 | |||
11840 | 190512 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6015812.43568 | 2113078.6641 | 37.7829991439482 | -122.38896064551 | (37.7829991439482, -122.38896064551) | 6 | 2 | 9 | 28856 | 6 | |||
101853 | 190585 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015704.36743 | 2107948.44562 | 37.768906711711 | -122.388976223597 | (37.768906711711, -122.388976223597) | 14 | 3 | 9 | 310 | 20 | |||
84464 | 192463 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 797 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015621.73798 | 2103917.41169 | 37.7578337820092 | -122.388980559228 | (37.7578337820092, -122.388980559228) | 10 | 3 | 8 | 28856 | 29 | |||
108869 | 190509 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6015781.59143 | 2113041.17774 | 37.7828945051221 | -122.389064736672 | (37.7828945051221, -122.389064736672) | 6 | 2 | 9 | 28856 | 6 | |||
115359 | 190508 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6015770.77212 | 2113043.45731 | 37.7829001645608 | -122.389102326524 | (37.7829001645608, -122.389102326524) | 6 | 2 | 9 | 28856 | 6 | |||
32400 | 190513 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6015752.27988 | 2113127.25011 | 37.7831292155962 | -122.389172155267 | (37.7831292155962, -122.389172155267) | 6 | 2 | 9 | 28856 | 6 | |||
161603 | 190507 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015728.80884 | 2113104.84376 | 37.7830663916517 | -122.389251791158 | (37.7830663916517, -122.389251791158) | 6 | 2 | 9 | 28856 | 6 | |||
171523 | 190514 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015711.14838 | 2113170.08621 | 37.7832445536293 | -122.389317447061 | (37.7832445536293, -122.389317447061) | 6 | 2 | 9 | 28856 | 6 | |||
19360 | 80805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015535.39126 | 2104617.20142 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | 10 | 3 | 8 | 28856 | 29 | |||
8872 | 80804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532 | -122.389332239092 | (37.759796756532, -122.389332239092) | 10 | 3 | 8 | 28856 | 29 | |||
34837 | 190506 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015686.96793 | 2113146.64908 | 37.7831788599674 | -122.389399465239 | (37.7831788599674, -122.389399465239) | 6 | 2 | 9 | 28856 | 6 | |||
79253 | 34850 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1016 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1997 12:00:00 AM | 8 | Permit Number 38472 | 6015493.82496 | 2104313.14645 | 37.7589132940426 | -122.389450575481 | (37.7589132940426, -122.389450575481) | 10 | 3 | 8 | 28856 | 29 | ||
31533 | 190515 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015672.13111 | 2113216.39507 | 37.7833695441175 | -122.389455667442 | (37.7833695441175, -122.389455667442) | 6 | 2 | 9 | 28856 | 6 | |||
189070 | 59618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1004 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 2 | Permit Number 31152 | 6015486.09515 | 2104460.82151 | 37.7593183495794 | -122.389487622149 | (37.7593183495794, -122.389487622149) | 10 | 3 | 8 | 28856 | 29 | |
166595 | 190586 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015582.84086 | 2109273.77078 | 37.7725390266763 | -122.389489148317 | (37.7725390266763, -122.389489148317) | 14 | 3 | 9 | 310 | 20 | |||
183738 | 190587 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015583.31199 | 2109308.81865 | 37.7726352865222 | -122.389489966697 | (37.7726352865222, -122.389489966697) | 14 | 3 | 9 | 310 | 20 | |||
183085 | 190588 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6015580.36907 | 2109321.80204 | 37.7726707728775 | -122.389501053548 | (37.7726707728775, -122.389501053548) | 14 | 3 | 9 | 310 | 20 | |||
93319 | 190589 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015580.04197 | 2109334.21151 | 37.7727048284094 | -122.389503051837 | (37.7727048284094, -122.389503051837) | 14 | 3 | 9 | 310 | 20 | |||
79701 | 190590 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015578.74967 | 2109351.03033 | 37.7727509375275 | -122.389508696885 | (37.7727509375275, -122.389508696885) | 14 | 3 | 9 | 310 | 20 | |||
22774 | 121447 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1251 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015574 | 2109248 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | 14 | 3 | 9 | 310 | 20 | |||||
11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
37647 | 44195 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
42164 | 44189 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
51369 | 44194 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
72872 | 44190 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
111099 | 44201 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
121191 | 44192 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
142441 | 44193 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 |
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) );