trees
8,659 rows where qSpecies_id = 11 sorted by Zip Codes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2919 | 208356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4998 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990631.22914 | 2093445.14336 | 37.7276627189546 | -122.474642998593 | (37.7276627189546, -122.474642998593) | 9 | 8 | 4 | 64 | 40 | |||
| 9536 | 1292 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5992119.08452 | 2087279.95314 | 37.710820711192 | -122.469051013205 | (37.710820711192, -122.469051013205) | 9 | 8 | 4 | 64 | 24 | |||
| 11356 | 208342 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990572.11827 | 2092496.71048 | 37.7250551346827 | -122.474778147818 | (37.7250551346827, -122.474778147818) | 9 | 8 | 4 | 64 | 40 | |||
| 13163 | 255351 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 17325 | 208354 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990627.1725 | 2093396.83669 | 37.7275298459097 | -122.474653498173 | (37.7275298459097, -122.474653498173) | 9 | 8 | 4 | 64 | 40 | |||
| 18240 | 208338 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3660 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5990543.735 | 2092084.7933 | 37.7239224682242 | -122.474846212085 | (37.7239224682242, -122.474846212085) | 9 | 8 | 4 | 64 | 40 | |||
| 20464 | 208353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990626.63647 | 2093347.44726 | 37.727394203873 | -122.474651748098 | (37.727394203873, -122.474651748098) | 9 | 8 | 4 | 64 | 40 | |||
| 21376 | 418 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3870 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 2X4 | 5990907.498 | 2090050.47073 | 37.7183577952661 | -122.473440442237 | (37.7183577952661, -122.473440442237) | 9 | 8 | 4 | 64 | 40 | ||
| 25324 | 29368 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 10 | 3X3 | 5992911.10359 | 2087617.08951 | 37.7117921381675 | -122.466338121928 | (37.7117921381675, -122.466338121928) | 9 | 8 | 4 | 64 | 24 | ||
| 25575 | 334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2008 12:00:00 AM | 3 | 2 | 5990580.28082 | 2092709.64357 | 37.7256402686825 | -122.474765465576 | (37.7256402686825, -122.474765465576) | 9 | 8 | 4 | 64 | 40 | ||
| 26197 | 177217 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 6 | : | Tree | Private 2 | 8 | Width 3ft | 5993336.53195 | 2087626.25376 | 37.7118418391946 | -122.464868401251 | (37.7118418391946, -122.464868401251) | 9 | 8 | 4 | 64 | 24 | |||
| 26969 | 87572 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3250 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2008 12:00:00 AM | 3 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.474535101923 | (37.7294662695904, -122.474535101923) | 9 | 8 | 4 | 64 | 40 | |||
| 28677 | 178295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 3x6 | 5990056.81744 | 2088683.04681 | 37.7145538887276 | -122.47628102917 | (37.7145538887276, -122.47628102917) | 1 | 8 | 4 | 64 | 14 | |||
| 33399 | 1276 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3995X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/1990 12:00:00 AM | 3 | 3X3 | 5992475.08932 | 2087359.09364 | 37.7110585755552 | -122.467826341637 | (37.7110585755552, -122.467826341637) | 9 | 8 | 4 | 64 | 24 | ||
| 36199 | 255343 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 38418 | 208368 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 4 | Width 0ft | 5991246.55637 | 2092406.78265 | 37.7248472743708 | -122.472440157794 | (37.7248472743708, -122.472440157794) | 9 | 8 | 4 | 64 | 40 | |||
| 38734 | 175106 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990415.51721 | 2088495.51708 | 37.71405977332 | -122.475027549593 | (37.71405977332, -122.475027549593) | 1 | 8 | 4 | 64 | 14 | |||
| 39260 | 1309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4027 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1990 12:00:00 AM | 12 | 3x6 | 5991894.9163 | 2087061.71161 | 37.7102085174809 | -122.469809904302 | (37.7102085174809, -122.469809904302) | 9 | 8 | 4 | 64 | 24 | ||
| 39787 | 255358 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 41352 | 208331 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990506.75522 | 2091505.28187 | 37.7223291312546 | -122.474931762787 | (37.7223291312546, -122.474931762787) | 9 | 8 | 4 | 64 | 40 | |||
| 41398 | 1305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4001 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/1990 12:00:00 AM | 12 | 3X6 | 5991918.74663 | 2087079.07842 | 37.710257579983 | -122.469728806135 | (37.710257579983, -122.469728806135) | 9 | 8 | 4 | 64 | 24 | ||
| 44437 | 11643 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2000 12:00:00 AM | 3 | 2x2 | 5991362.1134613 | 2093824.2614448 | 37.7287460056648 | -122.472143968924 | (37.7287460056648, -122.472143968924) | 9 | 8 | 4 | 64 | 40 | ||
| 45046 | 414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3858 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 3 | 2X3 | 5990846.47129 | 2090136.68952 | 37.7185909966546 | -122.473657669867 | (37.7185909966546, -122.473657669867) | 9 | 8 | 4 | 64 | 40 | ||
| 47386 | 348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 49862 | 340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
| 51057 | 1290 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2009 12:00:00 AM | 10 | 3x3 | 5992171.95554 | 2087305.71814 | 37.710894510437 | -122.468870154131 | (37.710894510437, -122.468870154131) | 9 | 8 | 4 | 64 | 24 | ||
| 51442 | 321 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3484X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 53677 | 1223 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 54816 | 1220 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 20 | 5993502.10505 | 2087589.31821 | 37.711749968047 | -122.464293459283 | (37.711749968047, -122.464293459283) | 9 | 8 | 4 | 64 | 24 | |||
| 55788 | 11740 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
| 56921 | 255350 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 58576 | 110367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3430X 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5990574 | 2092494 | 37.7250478014243 | -122.474771445203 | (37.7250478014243, -122.474771445203) | 9 | 8 | 4 | 64 | 40 | ||||
| 59019 | 255359 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 60499 | 175107 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990408.51338 | 2088499.51505 | 37.7140703448535 | -122.475052048918 | (37.7140703448535, -122.475052048918) | 1 | 8 | 4 | 64 | 14 | |||
| 60518 | 208348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3586 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990586.58923 | 2092794.78382 | 37.725874408051 | -122.474749869538 | (37.725874408051, -122.474749869538) | 9 | 8 | 4 | 64 | 40 | |||
| 60870 | 361 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/1994 12:00:00 AM | 20 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 61292 | 328 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3446X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 8 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 64125 | 208351 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990621.38884 | 2093295.18261 | 37.7272503941904 | -122.474666076081 | (37.7272503941904, -122.474666076081) | 9 | 8 | 4 | 64 | 40 | |||
| 64674 | 208335 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3684 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990511.32014 | 2091590.21454 | 37.7225625997689 | -122.474922179615 | (37.7225625997689, -122.474922179615) | 9 | 8 | 4 | 64 | 40 | |||
| 65021 | 1315 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/1990 12:00:00 AM | 6 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | ||
| 65083 | 87571 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3250 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2008 12:00:00 AM | 3 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.474535101923 | (37.7294662695904, -122.474535101923) | 9 | 8 | 4 | 64 | 40 | |||
| 66886 | 325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3462X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 67594 | 208334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3686 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990510.95904 | 2091573.10598 | 37.7225156029966 | -122.474922179633 | (37.7225156029966, -122.474922179633) | 9 | 8 | 4 | 64 | 40 | |||
| 69118 | 208347 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3592 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990579.24588 | 2092689.5726 | 37.7255850988498 | -122.474767578954 | (37.7255850988498, -122.474767578954) | 9 | 8 | 4 | 64 | 40 | |||
| 69211 | 87573 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5990532.67947 | 2091850.16405 | 37.7232775941572 | -122.474867310897 | (37.7232775941572, -122.474867310897) | 9 | 8 | 4 | 64 | 40 | ||||
| 69630 | 1240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3702X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X5 | 5993007.23866 | 2087630.97634 | 37.711835814643 | -122.466006863839 | (37.711835814643, -122.466006863839) | 9 | 8 | 4 | 64 | 24 | |||
| 69737 | 255346 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 70149 | 98853 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4043X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 5991835.94326 | 2086997.82238 | 37.710029684074 | -122.470009076276 | (37.710029684074, -122.470009076276) | 9 | 8 | 4 | 64 | 24 | |||||
| 70347 | 177216 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 4 | : | Tree | Private 2 | 9 | Width 3ft | 5993403.40349 | 2087610.58828 | 37.7118026809134 | -122.464636139668 | (37.7118026809134, -122.464636139668) | 9 | 8 | 4 | 64 | 24 | |||
| 70570 | 1303 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 11 | Median : Cutout | Tree | DPW 1 | 45 | 10 | 5991684.00883 | 2086976.46739 | 37.7099622642104 | -122.470532631883 | (37.7099622642104, -122.470532631883) | 9 | 8 | 4 | 64 | 24 | |||
| 70679 | 363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 8 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 71653 | 255362 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 43 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 72721 | 208344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3596 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990576.13534 | 2092600.13412 | 37.7253393429133 | -122.474771806674 | (37.7253393429133, -122.474771806674) | 9 | 8 | 4 | 64 | 40 | |||
| 73079 | 319 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3488X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1999 12:00:00 AM | 4 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 73237 | 208362 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4988 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990647.46748 | 2093708.52235 | 37.7283868323881 | -122.474606076933 | (37.7283868323881, -122.474606076933) | 9 | 8 | 4 | 64 | 40 | |||
| 75226 | 208332 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3688 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990508.37607 | 2091529.54171 | 37.7223958366684 | -122.474927929903 | (37.7223958366684, -122.474927929903) | 9 | 8 | 4 | 64 | 40 | |||
| 78327 | 104953 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 78916 | 177224 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989267.30759 | 2089305.68388 | 37.7162176785877 | -122.479055380104 | (37.7162176785877, -122.479055380104) | 1 | 8 | 4 | 64 | 14 | ||||
| 79357 | 87583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3422X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 5990574.05576 | 2092494.61094 | 37.725049482144 | -122.47477129702 | (37.725049482144, -122.47477129702) | 9 | 8 | 4 | 64 | 40 | |||
| 79459 | 177215 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5993434.69457 | 2087605.54338 | 37.7117906327114 | -122.464527623844 | (37.7117906327114, -122.464527623844) | 9 | 8 | 4 | 64 | 24 | |||
| 79627 | 208349 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3582 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990590.81907 | 2092867.71104 | 37.7260748930409 | -122.474740567819 | (37.7260748930409, -122.474740567819) | 9 | 8 | 4 | 64 | 40 | |||
| 80950 | 255115 | Property Tree 8 | Lophostemon confertus :: Brisbane Box 11 | 301X Chester Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
| 84938 | 208333 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3686 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990510.05543 | 2091556.56109 | 37.7224701224819 | -122.474924096089 | (37.7224701224819, -122.474924096089) | 9 | 8 | 4 | 64 | 40 | |||
| 84946 | 1254 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3802X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5992777.10247 | 2087583.7041 | 37.711692737 | -122.466798837414 | (37.711692737, -122.466798837414) | 9 | 8 | 4 | 64 | 24 | ||||
| 85877 | 255357 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 38 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 87156 | 177223 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989192.47222 | 2089346.91127 | 37.7163265325079 | -122.47931705855 | (37.7163265325079, -122.47931705855) | 1 | 8 | 4 | 64 | 14 | ||||
| 87385 | 1222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 12 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 88408 | 255349 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 89291 | 87588 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 5990484.73648 | 2091103.44002 | 37.7212244974117 | -122.474978557179 | (37.7212244974117, -122.474978557179) | 9 | 8 | 4 | 64 | 40 | ||||
| 93618 | 255344 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 95564 | 255355 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 36 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 95797 | 208343 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3598 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990575.95552 | 2092591.61389 | 37.7253159380728 | -122.474771806691 | (37.7253159380728, -122.474771806691) | 9 | 8 | 4 | 64 | 40 | |||
| 100311 | 255356 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 101209 | 323 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3482X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 102513 | 27534 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3721X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2000 12:00:00 AM | 18 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 102927 | 208340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3650 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990558.39265 | 2092291.57741 | 37.7244910951611 | -122.474810629503 | (37.7244910951611, -122.474810629503) | 9 | 8 | 4 | 64 | 40 | |||
| 104161 | 208341 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3646 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990562.32089 | 2092351.62749 | 37.7246562053147 | -122.474801431241 | (37.7246562053147, -122.474801431241) | 9 | 8 | 4 | 64 | 40 | |||
| 105270 | 11862 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 0 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 105419 | 87578 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3446X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 5990574.05576 | 2092494.61094 | 37.725049482144 | -122.47477129702 | (37.725049482144, -122.47477129702) | 9 | 8 | 4 | 64 | 40 | |||
| 106289 | 336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/07/2015 01:06:00 PM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 107316 | 350 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2000 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 107912 | 208336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3682 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990514.86 | 2091626.58074 | 37.7226626574396 | -122.474912596441 | (37.7226626574396, -122.474912596441) | 9 | 8 | 4 | 64 | 40 | |||
| 109920 | 177220 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989003.16824 | 2089530.29069 | 37.7168190498446 | -122.479984789888 | (37.7168190498446, -122.479984789888) | 1 | 8 | 4 | 64 | 14 | ||||
| 111288 | 1256 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3800X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 0 | 5992948.4963594 | 2087630.4709831 | 37.7118310379998 | -122.466209855136 | (37.7118310379998, -122.466209855136) | 9 | 8 | 4 | 64 | 24 | |||
| 113366 | 87584 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3422X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 5990574.05576 | 2092494.61094 | 37.725049482144 | -122.47477129702 | (37.725049482144, -122.47477129702) | 9 | 8 | 4 | 64 | 40 | |||
| 114777 | 255353 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 115876 | 208361 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4988 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990643.97998 | 2093666.02916 | 37.7282699546947 | -122.47461503327 | (37.7282699546947, -122.47461503327) | 9 | 8 | 4 | 64 | 40 | |||
| 116257 | 333 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3498X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2008 12:00:00 AM | 25 | 2 | 5990578.06761 | 2092479.06027 | 37.7250070163682 | -122.474756294138 | (37.7250070163682, -122.474756294138) | 9 | 8 | 4 | 64 | 40 | ||
| 116334 | 362 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 8 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 116771 | 177219 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988139.55796 | 2089802.05972 | 37.7175150450661 | -122.48298973781 | (37.7175150450661, -122.48298973781) | 1 | 8 | 4 | 64 | 14 | ||||
| 117871 | 68001 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 544 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31726 | 5992609.62348156 | 2089875.15957404 | 37.717974854222 | -122.467544217027 | (37.717974854222, -122.467544217027) | 9 | 8 | 6 | 64 | 24 | ||
| 118526 | 1225 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 120087 | 87587 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 5990484.73648 | 2091103.44002 | 37.7212244974117 | -122.474978557179 | (37.7212244974117, -122.474978557179) | 9 | 8 | 4 | 64 | 40 | |||
| 125633 | 208357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4996 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990633.47025 | 2093479.37398 | 37.7277568374993 | -122.474637748344 | (37.7277568374993, -122.474637748344) | 9 | 8 | 4 | 64 | 40 | |||
| 125947 | 82459 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 5990490.7241463 | 2091103.05558594 | 37.7212237888572 | -122.474957831695 | (37.7212237888572, -122.474957831695) | 9 | 8 | 4 | 64 | 40 | ||||
| 126672 | 208329 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5991167.98634 | 2094343.99841 | 37.7301618368806 | -122.47285295472 | (37.7301618368806, -122.47285295472) | 9 | 8 | 4 | 64 | 40 | |||
| 127253 | 208364 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4986 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990655.76988 | 2093825.72859 | 37.7287091323102 | -122.47458592582 | (37.7287091323102, -122.47458592582) | 9 | 8 | 4 | 64 | 40 | |||
| 127684 | 255354 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 35 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 128585 | 11856 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 0 | 4x9 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
| 130604 | 208355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990628.69493 | 2093421.0007 | 37.7275962824302 | -122.474649998016 | (37.7275962824302, -122.474649998016) | 9 | 8 | 4 | 64 | 40 |
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) );