trees
87 rows where Neighborhoods (old) = 22 and qSpecies_id = 50 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38739 | 229867 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | ||
28908 | 229866 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.425019400031 | (37.7430558262652, -122.425019400031) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
10934 | 226371 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 626 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002431.85737 | 2098894.22226 | 37.7433013483718 | -122.43423751036 | (37.7433013483718, -122.43423751036) | 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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
151810 | 226467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 11 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726947 | (37.7455007798334, -122.42261726947) | 2 | 7 | 5 | 28859 | 22 | |||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
121342 | 226766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005428.90079 | 2099643.28917 | 37.7455277666988 | -122.423927754381 | (37.7455277666988, -122.423927754381) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
55153 | 229747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.7455334252207 | -122.423931669125 | (37.7455334252207, -122.423931669125) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
153280 | 226762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005544.98011 | 2099653.84342 | 37.7455632989187 | -122.423527119901 | (37.7455632989187, -122.423527119901) | 2 | 7 | 5 | 28859 | 22 | |||
35141 | 32262 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | 2 | 7 | 5 | 28859 | 22 | |
167928 | 226763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.423709577049 | (37.7463491139326, -122.423709577049) | 2 | 7 | 5 | 28859 | 22 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||
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 | |||
74013 | 229876 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 231 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004828.77791 | 2100152.44223 | 37.746891885367 | -122.42603912601 | (37.746891885367, -122.42603912601) | 2 | 7 | 5 | 63 | 22 | |||
181529 | 229746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 6005420.74895 | 2100228.937 | 37.7471353615169 | -122.423997581329 | (37.7471353615169, -122.423997581329) | 2 | 7 | 5 | 28859 | 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 | |||
158762 | 229744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006129.97006 | 2100227.10081 | 37.7471703352582 | -122.421545017711 | (37.7471703352582, -122.421545017711) | 2 | 7 | 5 | 28859 | 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 | |||
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 | |||
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 | |||
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 | |||
133178 | 108708 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.85423 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | 2 | 4 | 5 | 63 | 22 | |
131153 | 226364 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001531.18753 | 2100555.73376 | 37.7478123046113 | -122.437470743076 | (37.7478123046113, -122.437470743076) | 2 | 4 | 5 | 63 | 22 | |||
123496 | 226373 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4222 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002349.44402 | 2100642.72182 | 37.7480976397016 | -122.434647475301 | (37.7480976397016, -122.434647475301) | 2 | 4 | 5 | 28862 | 22 | |||
75775 | 226372 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4222 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002353.94285 | 2100643.26716 | 37.748099392475 | -122.434631957518 | (37.748099392475, -122.434631957518) | 2 | 4 | 5 | 28862 | 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 | ||
127610 | 226368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002219.8956 | 2101222.17774 | 37.7496813332396 | -122.43513688726 | (37.7496813332396, -122.43513688726) | 2 | 4 | 5 | 28862 | 22 | |||
116513 | 220576 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4248 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781634 | 6002235.87131 | 2101222.78245 | 37.7496839007903 | -122.435081685973 | (37.7496839007903, -122.435081685973) | 2 | 4 | 5 | 28862 | 22 | |
113498 | 67792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52966 | 6002229.57555078 | 2101227.41307609 | 37.7496962578989 | -122.435103788069 | (37.7496962578989, -122.435103788069) | 2 | 4 | 5 | 28862 | 22 | |
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 | |||
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 | |||
140045 | 226369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | 2 | 4 | 5 | 28862 | 22 | |||
156574 | 226370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.436090732519 | (37.7499246016413, -122.436090732519) | 2 | 4 | 5 | 28862 | 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 | |||
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 | ||
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 | ||
176654 | 226367 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.7523360311927 | -122.438680460736 | (37.7523360311927, -122.438680460736) | 2 | 4 | 5 | 28862 | 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 | ||
52017 | 226767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001499.39319 | 2102307.79719 | 37.752621244884 | -122.437706147824 | (37.752621244884, -122.437706147824) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
2363 | 243655 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4140 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002213.79042 | 2102389.84201 | 37.7528871150509 | -122.435241509003 | (37.7528871150509, -122.435241509003) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
56867 | 229875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3771 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004599.42844 | 2102480.09049 | 37.7532701021595 | -122.42699795081 | (37.7532701021595, -122.42699795081) | 2 | 4 | 5 | 28862 | 22 | |||
52818 | 229871 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004840.3014 | 2102492.95724 | 37.7533190486424 | -122.426165878261 | (37.7533190486424, -122.426165878261) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
148052 | 229872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004865.55222 | 2102495.62663 | 37.7533278053416 | -122.426078745663 | (37.7533278053416, -122.426078745663) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
39925 | 226768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001810.12784 | 2102797.39865 | 37.7539832366425 | -122.436666617866 | (37.7539832366425, -122.436666617866) | 2 | 4 | 5 | 28862 | 22 | |||
91105 | 226769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001809.15664 | 2102809.6039 | 37.7540166941382 | -122.4366708501 | (37.7540166941382, -122.4366708501) | 2 | 4 | 5 | 28862 | 22 | |||
90350 | 226770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001804.17577 | 2102825.14189 | 37.7540590746692 | -122.436689187264 | (37.7540590746692, -122.436689187264) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
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 | |
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 | ||
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 | |||
32703 | 226374 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001383.53668 | 2102929.36368 | 37.7543213286885 | -122.438151321247 | (37.7543213286885, -122.438151321247) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | ||
170230 | 229874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004568.82488 | 2103108.44768 | 37.7549936933086 | -122.42714853777 | (37.7549936933086, -122.42714853777) | 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 | ||
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 | ||
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 | ||
62332 | 5527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 882 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005005.94295 | 2103241.13664 | 37.7553827355522 | -122.425646301253 | (37.7553827355522, -122.425646301253) | 2 | 4 | 5 | 28862 | 22 | |||
3767 | 226772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002600.09968 | 2103291.61408 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | 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 | |||
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 | ||
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 | |
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) );