trees
1,194 rows where qSpecies_id = 50 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188574 | 226773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.7530417058104 | -122.432759865801 | (37.7530417058104, -122.432759865801) | 2 | 4 | 5 | 28862 | 22 | |||
155526 | 226784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003023.04842 | 2105091.71244 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | 2 | 4 | 5 | 28862 | 3 | |||
163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
58895 | 94579 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 615 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53757 | 6003043 | 2104661 | 37.7591702275755 | -122.432536159886 | (37.7591702275755, -122.432536159886) | 2 | 4 | 5 | 28862 | 3 | ||
104313 | 226800 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 611 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2010 12:00:00 AM | 3 | Width 3ft | Permit Number 53757 | 6003049.61247 | 2104666.39775 | 37.7591854234811 | -122.432513676359 | (37.7591854234811, -122.432513676359) | 2 | 4 | 5 | 28862 | 3 | |
31344 | 226771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 822 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003061.62277 | 2103431.29043 | 37.7557947949988 | -122.432383924871 | (37.7557947949988, -122.432383924871) | 2 | 4 | 5 | 28862 | 22 | |||
24874 | 37335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 822 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53759 | 6003062.69037898 | 2103433.56920909 | 37.7558011125208 | -122.432380395486 | (37.7558011125208, -122.432380395486) | 2 | 4 | 5 | 28862 | 22 | |
13157 | 253697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 865 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003091 | 2107654 | 37.7673910038901 | -122.432583941874 | (37.7673910038901, -122.432583941874) | 15 | 5 | 5 | 28862 | 3 | ||||
157868 | 226819 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | 15 | 5 | 5 | 29492 | 9 | |||
6402 | 94573 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3978 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116 | 2105363 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | 15 | 4 | 5 | 28862 | 3 | ||
59850 | 107808 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 3979 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003121.6 | 2105304 | 37.7609402081383 | -122.432310246363 | (37.7609402081383, -122.432310246363) | 2 | 4 | 5 | 28862 | 3 | |||
72482 | 64228 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2012 12:00:00 AM | Permit Number 769264 | 6003122.11049357 | 2108174.45220479 | 37.7688218028269 | -122.43251351352 | (37.7688218028269, -122.43251351352) | 15 | 5 | 5 | 28862 | 3 | |||
181243 | 226780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3980 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003123.97049 | 2105369.10011 | 37.7611190917893 | -122.432306697403 | (37.7611190917893, -122.432306697403) | 15 | 4 | 5 | 28862 | 3 | |||
108610 | 226808 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 26 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003130.24955 | 2108135.8166 | 37.7687161804393 | -122.432482601186 | (37.7687161804393, -122.432482601186) | 15 | 5 | 5 | 28862 | 3 | |||
124976 | 226779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003146.24554 | 2105369.35546 | 37.76112105592 | -122.432229675877 | (37.76112105592, -122.432229675877) | 15 | 4 | 5 | 28862 | 3 | |||
183347 | 68748 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53751 | 6003148.31037661 | 2105371.6272327 | 37.7611274107355 | -122.432222696746 | (37.7611274107355, -122.432222696746) | 15 | 4 | 5 | 28862 | 3 | |
131236 | 226814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003182.02121 | 2107933.96626 | 37.7681648843321 | -122.432289109354 | (37.7681648843321, -122.432289109354) | 15 | 5 | 5 | 28862 | 3 | |||
159081 | 100089 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.433055234626 | (37.7984262977915, -122.433055234626) | 13 | 9 | 1 | 57 | 17 | |||
179824 | 100088 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003201.40964 | 2118956.65929 | 37.7984315255609 | -122.433009662373 | (37.7984315255609, -122.433009662373) | 13 | 9 | 1 | 57 | 17 | |||
86588 | 226807 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 48 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003212.25535 | 2107433.99017 | 37.7667937860223 | -122.432148823236 | (37.7667937860223, -122.432148823236) | 15 | 5 | 5 | 28862 | 3 | |||
145866 | 91415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 46 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2009 12:00:00 AM | 3x3 | Permit Number 52098 | 6003215 | 2107427 | 37.7667747483278 | -122.432138830712 | (37.7667747483278, -122.432138830712) | 15 | 5 | 5 | 28862 | 3 | ||
60065 | 17889 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | 13 | 9 | 11 | 29490 | 27 | ||
13347 | 231129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 821 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | 15 | 5 | 5 | 28862 | 3 | |||
78203 | 229880 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 482 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003343.61389 | 2100112.58509 | 37.7466983971062 | -122.431171839302 | (37.7466983971062, -122.431171839302) | 2 | 7 | 5 | 63 | 22 | |||
16192 | 50 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 811 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003361.68382 | 2107697.25864 | 37.767525128208 | -122.431650773269 | (37.767525128208, -122.431650773269) | 15 | 5 | 5 | 28862 | 3 | |||
112490 | 226778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3934 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003366.66584 | 2105380.90028 | 37.761165250397 | -122.431468161443 | (37.761165250397, -122.431468161443) | 15 | 4 | 5 | 28862 | 3 | |||
8083 | 261467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | ||||
14543 | 48 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | |||
1985 | 47 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1998 12:00:00 AM | 6 | 3x3 | 6003389.55254 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | 15 | 5 | 5 | 28862 | 3 | ||
82529 | 226774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4069 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003404.88062 | 2101242.91418 | 37.7498054882307 | -122.431040646222 | (37.7498054882307, -122.431040646222) | 2 | 4 | 5 | 28862 | 22 | |||
69633 | 94514 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 476 27th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53699 | 6003420 | 2100114 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | 2 | 7 | 5 | 63 | 22 | ||||
6567 | 45 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1990 12:00:00 AM | 12 | 3x3 | 6003436.52432 | 2107742.06145 | 37.7676523876611 | -122.431395108624 | (37.7676523876611, -122.431395108624) | 15 | 5 | 5 | 28862 | 3 | ||
31239 | 226775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4065 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003443.87888 | 2101243.2515 | 37.7498086241662 | -122.430905812676 | (37.7498086241662, -122.430905812676) | 2 | 4 | 5 | 28862 | 22 | |||
5157 | 43 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 797 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003580.94003 | 2107704.34561 | 37.7675570127652 | -122.4308929011 | (37.7675570127652, -122.4308929011) | 7 | 9 | 5 | 28862 | 3 | |||
100520 | 226781 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 466 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 7x8 | 6003584.13439 | 2105555.33075 | 37.7616565176582 | -122.430728478955 | (37.7616565176582, -122.430728478955) | 15 | 4 | 5 | 28862 | 3 | |||
4536 | 224986 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003589.47712 | 2105476.68017 | 37.7614408647212 | -122.430704387917 | (37.7614408647212, -122.430704387917) | 15 | 4 | 5 | 28862 | 3 | |
761 | 224987 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003591.74199 | 2105457.02251 | 37.7613870178149 | -122.430695151865 | (37.7613870178149, -122.430695151865) | 15 | 4 | 5 | 28862 | 3 | |
18298 | 41 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 795 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003608.49948 | 2107706.26027 | 37.7675638314322 | -122.430797713246 | (37.7675638314322, -122.430797713246) | 7 | 9 | 5 | 28862 | 3 | |||
19081 | 231839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 783 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003644.59766 | 2107707.78097 | 37.7675700520556 | -122.430672962911 | (37.7675700520556, -122.430672962911) | 7 | 9 | 5 | 28862 | 3 | |||
118063 | 68774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32703 | 6003671.21705714 | 2105010.40354042 | 37.7601652112687 | -122.430388414345 | (37.7601652112687, -122.430388414345) | 2 | 4 | 5 | 28862 | 3 | ||
7683 | 38 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 775 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.7675715008638 | -122.430573990716 | (37.7675715008638, -122.430573990716) | 7 | 9 | 5 | 28862 | 3 | |||
2827 | 253039 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 531 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 13x6.5 | 6003687 | 2105184 | 37.7606427596565 | -122.43034621439 | (37.7606427596565, -122.43034621439) | 2 | 4 | 5 | 28862 | 3 | ||
95093 | 99510 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1949 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2012 12:00:00 AM | 3 | Permit Number 768796 | 6003707.79876 | 2118284.70068 | 37.7966152106739 | -122.431209412082 | (37.7966152106739, -122.431209412082) | 13 | 9 | 1 | 57 | 17 | ||
109741 | 39737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
130336 | 39735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
57678 | 226799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003733.12478 | 2104096.27114 | 37.7576587280713 | -122.430109091559 | (37.7576587280713, -122.430109091559) | 2 | 4 | 5 | 28862 | 3 | |||
184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
156001 | 226798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003742.96223 | 2104233.19003 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | 2 | 4 | 5 | 28862 | 3 | |||
39351 | 226812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | 7 | 9 | 5 | 28862 | 3 | |||
24196 | 226813 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.430288478441 | (37.7690073251557, -122.430288478441) | 7 | 9 | 5 | 28862 | 3 | |||
186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
31293 | 229879 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003795.059 | 2100140.55813 | 37.7468007768344 | -122.429612782729 | (37.7468007768344, -122.429612782729) | 2 | 7 | 5 | 63 | 22 | |||
74132 | 229869 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003810.99153 | 2099557.89821 | 37.7452018299076 | -122.42951614338 | (37.7452018299076, -122.42951614338) | 2 | 7 | 5 | 63 | 22 | |||
128537 | 229878 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | 2 | 7 | 5 | 63 | 22 | |||
175338 | 226824 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003840.68463 | 2095954.97206 | 37.7353107011233 | -122.429156618694 | (37.7353107011233, -122.429156618694) | 2 | 7 | 5 | 63 | 7 | |||
113449 | 37029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39639 | 6003842.3126639 | 2099561.92709037 | 37.7452146656232 | -122.429408127516 | (37.7452146656232, -122.429408127516) | 2 | 7 | 5 | 63 | 22 | ||
29492 | 94652 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847 | 2095961 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) | 2 | 7 | 5 | 63 | 7 |
116173 | 37022 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
175959 | 37023 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
130979 | 226810 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003888.71107 | 2106689.12082 | 37.7647868841307 | -122.429755942181 | (37.7647868841307, -122.429755942181) | 8 | 4 | 5 | 28862 | 3 | |||
76063 | 226809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.429747326692 | (37.7647210474575, -122.429747326692) | 8 | 4 | 5 | 28862 | 3 | |||
138763 | 226797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003894.50507 | 2104240.41525 | 37.7580636523416 | -122.429561252457 | (37.7580636523416, -122.429561252457) | 2 | 4 | 5 | 28862 | 3 | |||
4829 | 158177 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6003950.61422 | 2096725.29328 | 37.7374320507564 | -122.42883145083 | (37.7374320507564, -122.42883145083) | 2 | 7 | 5 | 63 | 7 | |||
2916 | 53252 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | 2 | 4 | 5 | 28862 | 22 | ||
149017 | 226776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 16 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6004065.40509 | 2102868.59003 | 37.7543066193819 | -122.428872407741 | (37.7543066193819, -122.428872407741) | 2 | 4 | 5 | 28862 | 22 | |||
33974 | 229877 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 376 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004079.13209 | 2100156.42335 | 37.7468604198839 | -122.428631616054 | (37.7468604198839, -122.428631616054) | 2 | 7 | 5 | 63 | 22 | |||
41208 | 226823 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004115.91768 | 2097275.83468 | 37.7389530669259 | -122.428299145692 | (37.7389530669259, -122.428299145692) | 2 | 7 | 5 | 63 | 7 | |||
130550 | 34378 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | 2 | 7 | 5 | 63 | 7 | ||
189425 | 37050 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 278 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39655 | 6004138.71288838 | 2098700.07455731 | 37.7428649936747 | -122.428321811345 | (37.7428649936747, -122.428321811345) | 2 | 7 | 5 | 63 | 22 | ||
98840 | 229870 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6004170.69747 | 2100746.77802 | 37.7484865785056 | -122.42835706113 | (37.7484865785056, -122.42835706113) | 2 | 4 | 5 | 28862 | 22 | |||
153879 | 39493 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40951 | 6004185.70363157 | 2100750.04388013 | 37.7484963949206 | -122.428305402815 | (37.7484963949206, -122.428305402815) | 2 | 4 | 5 | 28862 | 22 | ||
185908 | 226777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004194.76383 | 2103338.46367 | 37.7556041027521 | -122.428458541531 | (37.7556041027521, -122.428458541531) | 2 | 4 | 5 | 28862 | 22 | |||
18693 | 226764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004212.35359 | 2095476.21584 | 37.7340171774496 | -122.427837519201 | (37.7340171774496, -122.427837519201) | 2 | 7 | 5 | 28861 | 25 | |||
157299 | 226765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | 2 | 7 | 5 | 28861 | 25 | |||
39458 | 67919 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085455 | -122.427629821288 | (37.734399085455, -122.427629821288) | 2 | 7 | 5 | 28861 | 25 | ||
66767 | 88284 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 270 Whitney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | 2 | 7 | 5 | 63 | 7 | |||
49433 | 66285 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | 2 | 7 | 5 | 28861 | 25 | ||
64290 | 226822 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004297.5525 | 2098038.31795 | 37.7410569481125 | -122.427725448366 | (37.7410569481125, -122.427725448366) | 2 | 7 | 5 | 63 | 7 | |||
54136 | 226376 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.427528590399 | (37.7377492002742, -122.427528590399) | 2 | 7 | 5 | 63 | 7 | |||
193864 | 256057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39638 | 6004331 | 2099600 | 37.7453468607112 | -122.427721041632 | (37.7453468607112, -122.427721041632) | 2 | 7 | 5 | 63 | 22 | ||
133172 | 37028 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39638 | 6004336.0974524 | 2099589.08608997 | 37.7453171819754 | -122.427702638011 | (37.7453171819754, -122.427702638011) | 2 | 7 | 5 | 63 | 22 | ||
24224 | 229868 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 248 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6004337.80093 | 2099585.86328 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | 2 | 7 | 5 | 63 | 22 | |||
104885 | 176588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 151 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004383.65032 | 2094057.63554 | 37.73013176266 | -122.427144283984 | (37.73013176266, -122.427144283984) | 9 | 7 | 6 | 28861 | 5 | |||
11124 | 230876 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 241 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 01:31:00 PM | 3 | Width 4ft | 6004420.76549 | 2097018.25838 | 37.7382630656916 | -122.427226779685 | (37.7382630656916, -122.427226779685) | 2 | 7 | 5 | 63 | 7 | ||
136750 | 59221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2009 12:00:00 AM | 3x3 | Permit Number 52989 | 6004451.77295889 | 2107409.78146369 | 37.7667975133385 | -122.427859811231 | (37.7667975133385, -122.427859811231) | 8 | 4 | 5 | 28862 | 3 | |
48475 | 226811 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004456.5508 | 2107418.49179 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | 8 | 4 | 5 | 28862 | 3 | |||
11638 | 95638 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462 | 2107407 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | 8 | 4 | 5 | 28862 | 3 | |
12919 | 262245 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | ||||
16474 | 253340 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | |
158091 | 129102 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | 7 | 9 | 11 | 28852 | 10 | |||
62699 | 138952 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004470.5657 | 2110964.0931 | 37.7765578523866 | -122.428048123596 | (37.7765578523866, -122.428048123596) | 7 | 9 | 11 | 28852 | 10 | |||
74222 | 129101 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 4 | : | Tree | Private 2 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | 7 | 9 | 11 | 28852 | 10 | |||
36754 | 138953 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876 | (37.7765203347407, -122.42804020876) | 7 | 9 | 11 | 28852 | 10 | |||
50870 | 129100 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 3 | : | Tree | Private 2 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.428036263087 | (37.7764530246232, -122.428036263087) | 7 | 9 | 11 | 28852 | 10 | |||
72626 | 138954 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 719 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004474.577 | 2110934.0085 | 37.7764754744029 | -122.428032102975 | (37.7764754744029, -122.428032102975) | 7 | 9 | 11 | 28852 | 10 | |||
9084 | 52119 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | |
78054 | 52117 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | ||
113687 | 52118 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | ||
156427 | 229873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3571 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004534.15788 | 2103646.15858 | 37.7564681605797 | -122.427306727641 | (37.7564681605797, -122.427306727641) | 2 | 4 | 5 | 28862 | 22 |
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) );