trees
1,024 rows where qSpecies_id = 72 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175119 | 41527 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.26197 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | 10 | 3 | 8 | 58 | 1 | ||
92367 | 201499 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6018416.79538 | 2095102.47259 | 37.7337842710237 | -122.378701895477 | (37.7337842710237, -122.378701895477) | 10 | 3 | 8 | 58 | 1 | ||||
57862 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 1486 Innes Ave | Front Yard : Yard | Tree | Private 2 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | 10 | 3 | 8 | 58 | 1 | ||||||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4185 | 262568 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4200 | 262567 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
7613 | 262571 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
8223 | 262569 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
9120 | 262556 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
10281 | 262560 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15440 | 262565 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15813 | 262563 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15949 | 262561 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
16740 | 262573 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
17120 | 262555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18473 | 262562 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18684 | 262572 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
183516 | 203183 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015658.44629 | 2106386.75714 | 37.7646161091615 | -122.38902601186 | (37.7646161091615, -122.38902601186) | 14 | 3 | 9 | 310 | 29 | |||
115670 | 203182 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690804 | (37.7647506171774, -122.38903690804) | 14 | 3 | 9 | 310 | 29 | |||
149890 | 203181 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6015653.76081 | 2106475.18483 | 37.7648586527362 | -122.389048392363 | (37.7648586527362, -122.389048392363) | 14 | 3 | 9 | 310 | 29 | |||
173479 | 21880 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015651.4577 | 2106526.92513 | 37.7650005927304 | -122.389059971145 | (37.7650005927304, -122.389059971145) | 14 | 3 | 9 | 310 | 29 | ||
84096 | 21878 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015649.24797 | 2106571.51851 | 37.7651229140022 | -122.389070727941 | (37.7651229140022, -122.389070727941) | 14 | 3 | 9 | 310 | 29 | ||
66981 | 21876 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | 14 | 3 | 9 | 310 | 29 | ||
117715 | 21874 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.389092925009 | (37.7653597144938, -122.389092925009) | 14 | 3 | 9 | 310 | 29 | ||
26368 | 21872 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.389106512866 | (37.7655055845439, -122.389106512866) | 14 | 3 | 9 | 310 | 29 | ||
167000 | 21870 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015638.72465 | 2106753.7729 | 37.7656227617076 | -122.389119852494 | (37.7656227617076, -122.389119852494) | 14 | 3 | 9 | 310 | 29 | ||
118447 | 199444 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.7690242971552 | -122.389144413879 | (37.7690242971552, -122.389144413879) | 14 | 3 | 9 | 310 | 20 | |||
190852 | 21868 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015630.42851 | 2106799.74819 | 37.7657485399863 | -122.389151757746 | (37.7657485399863, -122.389151757746) | 14 | 3 | 9 | 310 | 29 | ||
151958 | 199445 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015653.75387 | 2108031.46585 | 37.7691318614794 | -122.38915709163 | (37.7691318614794, -122.38915709163) | 14 | 3 | 9 | 310 | 20 | |||
87364 | 199446 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6015650.90558 | 2108071.91419 | 37.7692427658814 | -122.389169768482 | (37.7692427658814, -122.389169768482) | 14 | 3 | 9 | 310 | 20 | |||
118214 | 199447 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6015650.08946 | 2108116.21417 | 37.7693643586962 | -122.389175685108 | (37.7693643586962, -122.389175685108) | 14 | 3 | 9 | 310 | 20 | |||
113342 | 21867 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 6015621.91024 | 2106888.57721 | 37.7659919729796 | -122.389187423983 | (37.7659919729796, -122.389187423983) | 14 | 3 | 9 | 310 | 29 | ||
146674 | 199448 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015646.98681 | 2108156.18094 | 37.7694739267051 | -122.389189208225 | (37.7694739267051, -122.389189208225) | 14 | 3 | 9 | 310 | 20 | |||
33535 | 21866 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015620.2045 | 2106919.86703 | 37.7660777934714 | -122.389195508891 | (37.7660777934714, -122.389195508891) | 14 | 3 | 9 | 310 | 29 | ||
21038 | 21865 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.389200128686 | (37.7661590490173, -122.389200128686) | 14 | 3 | 9 | 310 | 29 | ||
139996 | 21858 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.79594 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | 14 | 3 | 9 | 310 | 29 | ||
149244 | 199449 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1515 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015644.40714 | 2108197.8403 | 37.7695881711843 | -122.3892010406 | (37.7695881711843, -122.3892010406) | 14 | 3 | 9 | 310 | 20 | |||
120771 | 203180 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1800 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015618.5764 | 2107110.17004 | 37.7666002339304 | -122.389214429714 | (37.7666002339304, -122.389214429714) | 14 | 3 | 9 | 310 | 29 | |||
7466 | 203179 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1800 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015617.1468 | 2107140.95711 | 37.7666846892774 | -122.389221524481 | (37.7666846892774, -122.389221524481) | 14 | 3 | 9 | 310 | 29 | |||
139328 | 199450 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1455 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6015636.18722 | 2108347.40225 | 37.7699983798625 | -122.389239918305 | (37.7699983798625, -122.389239918305) | 14 | 3 | 9 | 310 | 20 | |||
109029 | 199451 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1455 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6015633.06498 | 2108386.39567 | 37.77010527416 | -122.389253441416 | (37.77010527416, -122.389253441416) | 14 | 3 | 9 | 310 | 20 | |||
28346 | 199452 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015631.41317 | 2108425.60277 | 37.7702128366907 | -122.389261893238 | (37.7702128366907, -122.389261893238) | 14 | 3 | 9 | 310 | 20 | |||
78387 | 199453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6015629.79574 | 2108466.51232 | 37.7703250756792 | -122.389270345061 | (37.7703250756792, -122.389270345061) | 14 | 3 | 9 | 310 | 20 | |||
117349 | 199466 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015602.95639 | 2107310.92304 | 37.7671505920487 | -122.389282476925 | (37.7671505920487, -122.389282476925) | 14 | 3 | 9 | 310 | 20 | |||
28663 | 199454 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015626.42459 | 2108505.26742 | 37.7704313017932 | -122.38928471262 | (37.7704313017932, -122.38928471262) | 14 | 3 | 9 | 310 | 20 | |||
121748 | 199455 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | 14 | 3 | 9 | 310 | 20 | |||
63004 | 199465 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015601.02096 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | 14 | 3 | 9 | 310 | 20 | |||
182287 | 199464 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015598.48485 | 2107402.18483 | 37.7674009291493 | -122.389304316962 | (37.7674009291493, -122.389304316962) | 14 | 3 | 9 | 310 | 20 | |||
29167 | 121439 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
90115 | 121443 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
125105 | 121442 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
133893 | 121441 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
135017 | 121440 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
47169 | 199463 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015595.21944 | 2107438.50948 | 37.7675004876899 | -122.38931814852 | (37.7675004876899, -122.38931814852) | 14 | 3 | 9 | 310 | 20 | |||
141762 | 199462 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6015592.10308 | 2107492.64638 | 37.7676489630463 | -122.389332708559 | (37.7676489630463, -122.389332708559) | 14 | 3 | 9 | 310 | 20 | |||
184351 | 199456 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.7712642152147 | -122.389359890563 | (37.7712642152147, -122.389359890563) | 14 | 3 | 9 | 310 | 20 | |||
123417 | 199457 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015609.11002 | 2108848.45381 | 37.7713726563476 | -122.389368573515 | (37.7713726563476, -122.389368573515) | 14 | 3 | 9 | 310 | 20 | |||
82423 | 199458 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6015604.63296 | 2108887.78773 | 37.7714804104287 | -122.389386807278 | (37.7714804104287, -122.389386807278) | 14 | 3 | 9 | 310 | 20 | |||
174800 | 199459 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015601.45578 | 2108929.34519 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | 14 | 3 | 9 | 310 | 20 | |||
81733 | 199460 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015600.77794 | 2108970.35206 | 37.7717069001893 | -122.389405908858 | (37.7717069001893, -122.389405908858) | 14 | 3 | 9 | 310 | 20 | |||
95405 | 199461 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015597.30963 | 2109009.91551 | 37.7718153404253 | -122.389420669423 | (37.7718153404253, -122.389420669423) | 14 | 3 | 9 | 310 | 20 | |||
73924 | 199489 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1500 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015558.23281 | 2108115.16925 | 37.7693563969951 | -122.389493342767 | (37.7693563969951, -122.389493342767) | 14 | 3 | 9 | 310 | 20 | |||
68538 | 256059 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1475 Underwood Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 6015203.6 | 2093200.6 | 37.7283844479575 | -122.389678175441 | (37.7283844479575, -122.389678175441) | 10 | 3 | 8 | 58 | 1 | |||||
173219 | 199488 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6015518.16764 | 2108801.30732 | 37.7712381600557 | -122.389679856761 | (37.7712381600557, -122.389679856761) | 14 | 3 | 9 | 310 | 20 | |||
142129 | 199487 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.389688878734 | (37.7713483755645, -122.389688878734) | 14 | 3 | 9 | 310 | 20 | |||
67094 | 199486 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015515.33955 | 2108860.86593 | 37.7714015380777 | -122.389693799846 | (37.7714015380777, -122.389693799846) | 14 | 3 | 9 | 310 | 20 | |||
39822 | 199485 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6015513.12326 | 2108880.27223 | 37.7714547006117 | -122.389702821822 | (37.7714547006117, -122.389702821822) | 14 | 3 | 9 | 310 | 20 | |||
153589 | 203176 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1301 Minnesota St | 12 | Front Yard : Yard | Tree | Private 2 | 12 | 6015380.59839 | 2102345.27771 | 37.7535036668642 | -122.389704723912 | (37.7535036668642, -122.389704723912) | 10 | 3 | 8 | 28856 | 29 | ||||
49886 | 199484 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015511.15614 | 2108923.75767 | 37.7715739929801 | -122.389712664004 | (37.7715739929801, -122.389712664004) | 14 | 3 | 9 | 310 | 20 | |||
7287 | 199483 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.389722506198 | (37.7716855044225, -122.389722506198) | 14 | 3 | 9 | 310 | 20 | |||
101266 | 199482 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015508.80687 | 2108983.54244 | 37.7717380185256 | -122.38972496674 | (37.7717380185256, -122.38972496674) | 14 | 3 | 9 | 310 | 20 | |||
106031 | 199481 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015507.54817 | 2109003.40137 | 37.7717924769768 | -122.389730708003 | (37.7717924769768, -122.389730708003) | 14 | 3 | 9 | 310 | 20 | |||
92549 | 203178 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1301 Minnesota St | 65 | Front Yard : Yard | Tree | Private 2 | 14 | 6015363.87101 | 2102334.663 | 37.7534735935428 | -122.38976182994 | (37.7534735935428, -122.38976182994) | 10 | 3 | 8 | 28856 | 29 | ||||
92852 | 199480 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015500.51903 | 2109136.7123 | 37.7721581296349 | -122.389764335453 | (37.7721581296349, -122.389764335453) | 14 | 3 | 9 | 310 | 20 | |||
112020 | 199479 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6015497.26335 | 2109186.83428 | 37.7722955730039 | -122.389779098738 | (37.7722955730039, -122.389779098738) | 14 | 3 | 9 | 310 | 20 | |||
42528 | 203177 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1301 Minnesota St | 61 | Front Yard : Yard | Tree | Private 2 | 17 | 6015358.55131 | 2102374.09965 | 37.7535815832452 | -122.389782981114 | (37.7535815832452, -122.389782981114) | 10 | 3 | 8 | 28856 | 29 | ||||
147799 | 199478 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015495.30582 | 2109230.79118 | 37.7724161604052 | -122.389788940918 | (37.7724161604052, -122.389788940918) | 14 | 3 | 9 | 310 | 20 | |||
91964 | 199477 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6015494.09745 | 2109276.62148 | 37.7725419332902 | -122.389796322564 | (37.7725419332902, -122.389796322564) | 14 | 3 | 9 | 310 | 20 | |||
137050 | 199476 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6015490.48538 | 2109320.84762 | 37.772663168207 | -122.389811906894 | (37.772663168207, -122.389811906894) | 14 | 3 | 9 | 310 | 20 | |||
28973 | 199475 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015486.6604 | 2109366.25847 | 37.7727876442643 | -122.389828310528 | (37.7727876442643, -122.389828310528) | 14 | 3 | 9 | 310 | 20 | |||
141054 | 199474 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | 14 | 3 | 9 | 310 | 20 | |||
1209 | 199473 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | 14 | 3 | 9 | 310 | 20 | |||
178771 | 199472 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | 14 | 3 | 9 | 310 | 20 | |||
132758 | 199471 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015471.47006 | 2109635.49599 | 37.7735260686063 | -122.389899666361 | (37.7735260686063, -122.389899666361) | 14 | 3 | 9 | 310 | 20 | |||
52778 | 199470 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543 | (37.7739526530238, -122.38994067543) | 14 | 3 | 9 | 310 | 20 | |||
30017 | 199467 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015455.2503 | 2109935.91808 | 37.7743500616368 | -122.389976763437 | (37.7743500616368, -122.389976763437) | 14 | 3 | 9 | 310 | 20 | |||
13473 | 105162 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
144253 | 84744 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | 6 | 2 | 9 | 28856 | 20 | ||
120071 | 84745 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 18 | Permit No. 49304 | 6015113.58647 | 2111549.96085 | 37.7787629081139 | -122.391271501195 | (37.7787629081139, -122.391271501195) | 6 | 2 | 9 | 28856 | 20 | ||
108937 | 84746 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | 6 | 2 | 9 | 28856 | 20 | ||
170619 | 84747 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | 6 | 2 | 9 | 28856 | 20 | ||
111082 | 84748 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | 6 | 2 | 9 | 28856 | 20 | ||
14282 | 84749 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | 6 | 2 | 9 | 28856 | 20 |
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) );