trees
272 rows where Supervisor Districts = 5 and qSpecies_id = 50 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
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 | ||
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 | ||||
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 | ||||
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 | ||||
13239 | 35575 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.423142532595 | (37.7559036789868, -122.423142532595) | 2 | 4 | 5 | 28859 | 19 | |
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 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 | |
25503 | 94663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614 | 2097695 | 37.7401321706185 | -122.426606846161 | (37.7401321706185, -122.426606846161) | 2 | 7 | 5 | 63 | 7 | |
25889 | 52052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48254 | 6005362.31259493 | 2099645.76538508 | 37.7455308063117 | -122.424158182307 | (37.7455308063117, -122.424158182307) | 2 | 7 | 5 | 28859 | 22 | |||
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
29877 | 39158 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
31441 | 50614 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.7427218255103 | -122.432972078444 | (37.7427218255103, -122.432972078444) | 2 | 7 | 5 | 63 | 22 | |||
32241 | 59724 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 19156 | 6001209.48230507 | 2102271.53927268 | 37.7525052007973 | -122.438706110204 | (37.7525052007973, -122.438706110204) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
40238 | 46344 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | 2 | 4 | 5 | 28859 | 19 | ||
40413 | 40242 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
42787 | 39159 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
48255 | 50560 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | 2 | 4 | 5 | 28862 | 22 | |||
49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
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 | ||
49516 | 36914 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 39560 | 6001809.10067712 | 2102876.63029352 | 37.7542007293515 | -122.436675841105 | (37.7542007293515, -122.436675841105) | 2 | 4 | 5 | 28862 | 22 | ||
49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
50547 | 55554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.7595513701063 | -122.44216582584 | (37.7595513701063, -122.44216582584) | 2 | 4 | 5 | 28862 | 3 | ||
52802 | 37414 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | 2 | 4 | 5 | 28862 | 22 | ||
55486 | 37153 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468 | (37.7471459516063, -122.42400799468) | 2 | 7 | 5 | 28859 | 22 | |||
55948 | 50586 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | 2 | 4 | 5 | 28862 | 22 | |||
56787 | 83340 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 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 | ||
61584 | 40245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
69045 | 37319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 584 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.434112472119 | (37.7553821115396, -122.434112472119) | 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 | ||||
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 | |||
78982 | 50683 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | 15 | 5 | 5 | 29492 | 9 | |||
79369 | 95629 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767396 | 6004866 | 2102499 | 37.753337093137 | -122.426077437274 | (37.753337093137, -122.426077437274) | 2 | 4 | 5 | 28862 | 22 | |
80034 | 95634 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767401 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
82797 | 37263 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39807 | 6004880.29315542 | 2103713.53429444 | 37.7566727279873 | -122.426114465107 | (37.7566727279873, -122.426114465107) | 2 | 4 | 5 | 28862 | 3 | ||
83461 | 36913 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39559 | 6001808.51272351 | 2102888.32664908 | 37.7542328113234 | -122.436678711571 | (37.7542328113234, -122.436678711571) | 2 | 4 | 5 | 28862 | 22 | ||
84695 | 37318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 584 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.434112472119 | (37.7553821115396, -122.434112472119) | 2 | 4 | 5 | 28862 | 22 | ||
85186 | 40244 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
85315 | 33045 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2000 12:00:00 AM | Permit Number 37322 | 6005530.37891091 | 2101176.15171839 | 37.7497423846708 | -122.423685826158 | (37.7497423846708, -122.423685826158) | 2 | 4 | 5 | 28859 | 19 | ||
85522 | 37415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39893 | 6001946.57451683 | 2101373.82273034 | 37.75008219015 | -122.436092890574 | (37.75008219015, -122.436092890574) | 2 | 4 | 5 | 28862 | 22 | ||
85838 | 33044 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 417 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37321 | 6005524.82070863 | 2101276.46802426 | 37.7500175164074 | -122.423712178429 | (37.7500175164074, -122.423712178429) | 2 | 4 | 5 | 28859 | 19 | ||
89909 | 40262 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45085 | 6005347.95435348 | 2101987.4938302 | 37.7519598434296 | -122.424374358675 | (37.7519598434296, -122.424374358675) | 2 | 4 | 5 | 28859 | 19 | ||
94618 | 84806 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53985 | 6002776 | 2103844 | 37.7569117968289 | -122.433401190257 | (37.7569117968289, -122.433401190257) | 2 | 4 | 5 | 28862 | 3 | |
99483 | 34194 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | Permit Number 38013 | 6005507.05529052 | 2099654.01670417 | 37.7455616340181 | -122.423658270556 | (37.7455616340181, -122.423658270556) | 2 | 7 | 5 | 28859 | 22 | |||
101368 | 40260 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41418 | 6006042.36187531 | 2101970.77964266 | 37.7519531379729 | -122.421971806823 | (37.7519531379729, -122.421971806823) | 2 | 4 | 5 | 28859 | 19 | ||
108705 | 36911 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39557 | 6001782.24940233 | 2103410.78892741 | 37.7556658745596 | -122.436806934863 | (37.7556658745596, -122.436806934863) | 2 | 4 | 5 | 28862 | 22 | ||
109286 | 37272 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39812 | 6004581.43700171 | 2103112.60503565 | 37.7550058216408 | -122.427105217543 | (37.7550058216408, -122.427105217543) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
110649 | 64206 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | Permit No. 49278 | 6001454.61421942 | 2102939.02028788 | 37.7543518855401 | -122.437906209203 | (37.7543518855401, -122.437906209203) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
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 | ||
117639 | 114960 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770791 | 6001920.2 | 2100491.9 | 37.7476591410723 | -122.436120992025 | (37.7476591410723, -122.436120992025) | 2 | 4 | 5 | 63 | 22 | |||
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 | ||
121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
126744 | 94041 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | Permit Number 53451 | 6005890 | 2099632 | 37.7455227900977 | -122.422332540821 | (37.7455227900977, -122.422332540821) | 2 | 7 | 5 | 28859 | 22 | |||
127792 | 33046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
130082 | 95630 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767398 | 6004828 | 2102496 | 37.753326708053 | -122.426208635682 | (37.753326708053, -122.426208635682) | 2 | 4 | 5 | 28862 | 22 | |
130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
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 | ||
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 | ||
132383 | 42046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | 2 | 7 | 5 | 28859 | 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 | ||
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 | |
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 | ||
153478 | 37047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.7430807339727 | -122.424735348964 | (37.7430807339727, -122.424735348964) | 2 | 7 | 5 | 63 | 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 | ||
155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
156239 | 35551 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
159162 | 87811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50591 | 6005544 | 2102537 | 37.7534797286848 | -122.423735471432 | (37.7534797286848, -122.423735471432) | 2 | 4 | 5 | 28859 | 19 | ||
159303 | 45811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 71 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44439 | 6000723.05882095 | 2104884.41992047 | 37.7596518513768 | -122.440575632448 | (37.7596518513768, -122.440575632448) | 2 | 4 | 5 | 28862 | 3 | |||
162120 | 58905 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018004 | 37.7584164881822 | -122.434678474426 | (37.7584164881822, -122.434678474426) | 2 | 4 | 5 | 28862 | 3 | ||
162653 | 251225 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x2.5 | 6000238 | 2104757 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | 2 | 4 | 5 | 28862 | 3 | ||||
165980 | 35552 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
166276 | 95624 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767391 | 6005934 | 2105520 | 37.761692359374 | -122.422598723522 | (37.761692359374, -122.422598723522) | 8 | 4 | 5 | 28859 | 19 | |
172051 | 35555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
174174 | 95221 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 299 on 16th St Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 774713 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | ||
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 | ||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
178845 | 34366 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | 2 | 7 | 5 | 63 | 7 | ||
181262 | 35309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38777 | 6005480.32103823 | 2105501.15439096 | 37.7616150083325 | -122.424166477384 | (37.7616150083325, -122.424166477384) | 8 | 4 | 5 | 28859 | 19 | ||
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 | |
184733 | 33040 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37317 | 6005440.04608192 | 2101847.29088497 | 37.751580078433 | -122.42404592247 | (37.751580078433, -122.42404592247) | 2 | 4 | 5 | 28859 | 19 | ||
185655 | 74908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
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 | ||
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 | ||
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 | |||
82467 | 226366 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001939.37968 | 2100462.15738 | 37.7475785645179 | -122.436052541893 | (37.7475785645179, -122.436052541893) | 2 | 4 | 5 | 63 | 22 | |||
88827 | 226362 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005992.12876 | 2102270.13031 | 37.7527722527625 | -122.422166785593 | (37.7527722527625, -122.422166785593) | 2 | 4 | 5 | 28859 | 19 | |||
106518 | 229741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 714 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004954.86133 | 2104148.63623 | 37.7578716299893 | -122.425887551571 | (37.7578716299893, -122.425887551571) | 2 | 4 | 5 | 28862 | 3 | |||
135145 | 226365 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001939.89483 | 2100487.05511 | 37.7476469570616 | -122.436052541887 | (37.7476469570616, -122.436052541887) | 2 | 4 | 5 | 63 | 22 | |||
140189 | 226761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005532.06027 | 2099607.16908 | 37.7454344125679 | -122.423568476998 | (37.7454344125679, -122.423568476998) | 2 | 7 | 5 | 28859 | 22 | |||
156800 | 10139 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.71608 | 37.7566603214356 | -122.42320418504 | (37.7566603214356, -122.42320418504) | 2 | 4 | 5 | 28859 | 19 |
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) );