trees
2,180 rows where qSpecies_id = 57 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23799 | 62094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22183 | 6013254.03052 | 2105108.1707 | 37.7609718188263 | -122.397252634924 | (37.7609718188263, -122.397252634924) | 10 | 3 | 8 | 28856 | 29 | |
24257 | 106128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6012212.28641 | 2101900.78254 | 37.7521069828692 | -122.400630274471 | (37.7521069828692, -122.400630274471) | 10 | 3 | 8 | 28856 | 29 | ||||
24736 | 191441 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.401033518791 | (37.7520763618475, -122.401033518791) | 10 | 3 | 8 | 28856 | 29 | |||
26208 | 191473 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014315.40863 | 2112455.42682 | 37.7812047833188 | -122.394096137746 | (37.7812047833188, -122.394096137746) | 6 | 2 | 9 | 28856 | 6 | |||
27870 | 191476 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014442.93612 | 2112579.76279 | 37.7815532688034 | -122.393663657352 | (37.7815532688034, -122.393663657352) | 6 | 2 | 9 | 28856 | 6 | |||
35970 | 122754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 6011277.36342 | 2105334.1858 | 37.7614821606899 | -122.404105006665 | (37.7614821606899, -122.404105006665) | 10 | 3 | 8 | 28856 | 29 | |||
36321 | 191463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014423.52986 | 2112756.14838 | 37.7820365051332 | -122.393743143935 | (37.7820365051332, -122.393743143935) | 6 | 2 | 9 | 28856 | 6 | |||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
41878 | 116060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | 10 | 3 | 8 | 28856 | 29 | ||
44258 | 67564 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869858 | -122.402685364734 | (37.756832869858, -122.402685364734) | 10 | 3 | 8 | 28856 | 29 | |
47240 | 191474 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6014326.75697 | 2112466.04784 | 37.7812345769599 | -122.39405762156 | (37.7812345769599, -122.39405762156) | 6 | 2 | 9 | 28856 | 6 | |||
48700 | 191468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014292.29593 | 2112680.88237 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | 6 | 2 | 9 | 28856 | 6 | |||
57752 | 101144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | 10 | 3 | 8 | 28856 | 29 | |||
59540 | 62093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 421 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 12 | Permit Number 22182 | 6013256.61588 | 2105083.54347 | 37.760904341792 | -122.397241966241 | (37.760904341792, -122.397241966241) | 10 | 3 | 8 | 28856 | 29 | |
61580 | 67593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 357 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31160 | 6013799.73337 | 2105430.83352 | 37.7618881461485 | -122.395387878055 | (37.7618881461485, -122.395387878055) | 10 | 3 | 8 | 28856 | 29 | |
62124 | 191480 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012537.84104 | 2111160.5359 | 37.7775503530914 | -122.400154712085 | (37.7775503530914, -122.400154712085) | 14 | 2 | 9 | 28856 | 34 | |||
62275 | 191483 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012443.09783 | 2111154.53509 | 37.7775285931066 | -122.400482041007 | (37.7775285931066, -122.400482041007) | 14 | 2 | 9 | 28856 | 34 | |||
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
84253 | 191465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014398.12583 | 2112729.40877 | 37.7819616725233 | -122.393829158687 | (37.7819616725233, -122.393829158687) | 6 | 2 | 9 | 28856 | 6 | |||
87859 | 67716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 560 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 18 | 4x9 | Permit Number 31329 | 6014049.28523 | 2112210.37006 | 37.7805171185161 | -122.394999630825 | (37.7805171185161, -122.394999630825) | 6 | 2 | 9 | 28856 | 34 |
89619 | 191475 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014428.20557 | 2112560.71307 | 37.7815001440537 | -122.393713284646 | (37.7815001440537, -122.393713284646) | 6 | 2 | 9 | 28856 | 6 | |||
90539 | 191478 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014500.76851 | 2112629.04154 | 37.7816917904788 | -122.393467033175 | (37.7816917904788, -122.393467033175) | 6 | 2 | 9 | 28856 | 6 | |||
90669 | 191462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 44 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014434.11551 | 2112764.95464 | 37.7820612733549 | -122.393707138698 | (37.7820612733549, -122.393707138698) | 6 | 2 | 9 | 28856 | 6 | |||
93436 | 67592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.395402814912 | (37.7619996710595, -122.395402814912) | 10 | 3 | 8 | 28856 | 29 | |
96281 | 191467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014304.88923 | 2112665.08125 | 37.7817798619958 | -122.394147212029 | (37.7817798619958, -122.394147212029) | 6 | 2 | 9 | 28856 | 6 | |||
100774 | 57997 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 407 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22184 | 6013252.80923 | 2105139.22095 | 37.7610570080038 | -122.397259036287 | (37.7610570080038, -122.397259036287) | 10 | 3 | 8 | 28856 | 29 | |
101328 | 191443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 19th St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6013161.12259 | 2105230.38347 | 37.7613022153415 | -122.397582536801 | (37.7613022153415, -122.397582536801) | 10 | 3 | 8 | 28856 | 29 | |||
109455 | 62083 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 11 | Permit Number 22167 | 6013240.89819 | 2104321.43892 | 37.7588108945258 | -122.397242884449 | (37.7588108945258, -122.397242884449) | 10 | 3 | 8 | 28856 | 29 | |
110109 | 116049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.7615544688802 | -122.403342277248 | (37.7615544688802, -122.403342277248) | 10 | 3 | 8 | 28856 | 29 | ||
117613 | 191472 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 171 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014194.16653 | 2112375.55603 | 37.7809787369144 | -122.394509984157 | (37.7809787369144, -122.394509984157) | 6 | 2 | 9 | 28856 | 6 | |||
124454 | 57616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 455 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 11 | Permit Number 22179 | 6013266.46923 | 2104945.7243 | 37.7605264691381 | -122.397198223232 | (37.7605264691381, -122.397198223232) | 10 | 3 | 8 | 28856 | 29 | |
125300 | 191484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012469.2774 | 2111178.20326 | 37.7775950404069 | -122.400393139428 | (37.7775950404069, -122.400393139428) | 14 | 2 | 9 | 28856 | 34 | |||
126424 | 191469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.394233893177 | (37.7818525865622, -122.394233893177) | 6 | 2 | 9 | 28856 | 6 | |||
127544 | 191437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300x De Haro St | 31 | Median : Yard | Tree | DPW 1 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | 10 | 3 | 8 | 28856 | 29 | ||||
128918 | 191444 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Connecticut St | 1 | : | Tree | Private 2 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | 14 | 3 | 8 | 28856 | 29 | |||
129881 | 107956 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
131462 | 191461 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 26 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014466.47326 | 2112793.29077 | 37.782140875944 | -122.393597178563 | (37.782140875944, -122.393597178563) | 6 | 2 | 9 | 28856 | 6 | |||
138358 | 191438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2209 25th St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | 6012142.94506 | 2101858.42279 | 37.7519868046503 | -122.400867092959 | (37.7519868046503, -122.400867092959) | 10 | 3 | 8 | 28856 | 29 | ||||
138738 | 191470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014270.76431 | 2112702.62209 | 37.7818810438134 | -122.394267898345 | (37.7818810438134, -122.394267898345) | 6 | 2 | 9 | 28856 | 6 | |||
139092 | 60030 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 19 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | 6 | 2 | 9 | 28856 | 6 | ||
141228 | 191435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1310 Indiana St | 1 | : Yard | Tree | Private 2 | 1 | 6014946.60084 | 2102566.45751 | 37.7540869042097 | -122.391221052827 | (37.7540869042097, -122.391221052827) | 10 | 3 | 8 | 28856 | 29 | ||||
144669 | 191479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6012522.42576 | 2111176.28412 | 37.7775927345574 | -122.400209145359 | (37.7775927345574, -122.400209145359) | 14 | 2 | 9 | 28856 | 34 | |||
144851 | 52006 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1489 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48222 | 6011774.4965411 | 2101419.07057833 | 37.7507598806074 | -122.402110363809 | (37.7507598806074, -122.402110363809) | 10 | 3 | 8 | 28856 | 29 | ||||
155274 | 191471 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 171 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014161.57896 | 2112368.90341 | 37.7809586586641 | -122.394622255529 | (37.7809586586641, -122.394622255529) | 6 | 2 | 9 | 28856 | 6 | |||
159719 | 191439 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2205 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.7519933949033 | -122.400702349738 | (37.7519933949033, -122.400702349738) | 10 | 3 | 8 | 28856 | 29 | |||
166744 | 40227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.01784 | 37.7813803084996 | -122.3938724152 | (37.7813803084996, -122.3938724152) | 6 | 2 | 9 | 28856 | 6 | ||
168508 | 101482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1021 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6011947.17708 | 2103416.1545 | 37.7562530733255 | -122.401653568078 | (37.7562530733255, -122.401653568078) | 10 | 3 | 8 | 28856 | 29 | |||
168813 | 191432 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6010899.91125 | 2105517.41089 | 37.7619641586404 | -122.405423368691 | (37.7619641586404, -122.405423368691) | 10 | 3 | 8 | 28856 | 29 | ||||
172933 | 62092 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | 10 | 3 | 8 | 28856 | 29 | ||
174377 | 191440 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2212 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6012152.29836 | 2101896.56279 | 37.7520920505116 | -122.400837427014 | (37.7520920505116, -122.400837427014) | 10 | 3 | 8 | 28856 | 29 | |||
175755 | 62091 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1401 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22178 | 6013163.83149517 | 2106111.21456306 | 37.7637209341904 | -122.397634949335 | (37.7637209341904, -122.397634949335) | 14 | 3 | 8 | 28856 | 29 | ||
177243 | 191442 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012056.70956 | 2101893.12707 | 37.7520772845403 | -122.40116774801 | (37.7520772845403, -122.40116774801) | 10 | 3 | 8 | 28856 | 29 | |||
178262 | 191436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6013098.64542 | 2106113.56036 | 37.7637237451866 | -122.397860573921 | (37.7637237451866, -122.397860573921) | 14 | 3 | 8 | 28856 | 29 | |||
181602 | 60022 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 64 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19509 | 6014593.22345076 | 2112850.04710835 | 37.782303758061 | -122.393162649296 | (37.782303758061, -122.393162649296) | 6 | 2 | 9 | 28856 | 6 | ||
182849 | 191466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 86 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014334.84424 | 2112669.08128 | 37.781792510069 | -122.394043861033 | (37.781792510069, -122.394043861033) | 6 | 2 | 9 | 28856 | 6 | |||
183319 | 101143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.7605945388373 | -122.397410636805 | (37.7605945388373, -122.397410636805) | 10 | 3 | 8 | 28856 | 29 | |||
184196 | 122755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.404117444276 | (37.7615439863765, -122.404117444276) | 10 | 3 | 8 | 28856 | 29 | |||
186811 | 191482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012422.29694 | 2111134.3733 | 37.7774720734215 | -122.400552582046 | (37.7774720734215, -122.400552582046) | 14 | 2 | 9 | 28856 | 34 | |||
190049 | 191481 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012554.15249 | 2111142.66479 | 37.7775021925975 | -122.400097029578 | (37.7775021925975, -122.400097029578) | 14 | 2 | 9 | 28856 | 34 | |||
190472 | 60025 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 155 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.394449015999 | (37.7813091831039, -122.394449015999) | 6 | 2 | 9 | 28856 | 6 | ||
190796 | 191464 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014410.76639 | 2112744.50721 | 37.7820038318593 | -122.393786484975 | (37.7820038318593, -122.393786484975) | 6 | 2 | 9 | 28856 | 6 | |||
13594 | 96006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009630.99676 | 2116399.7599 | 37.7917735027068 | -122.410580567837 | (37.7917735027068, -122.410580567837) | 5 | 1 | 10 | 28857 | 21 |
35027 | 96011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.64536 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) | 5 | 1 | 10 | 28857 | 21 |
45856 | 37501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.37561 | 2115737.1064 | 37.7899465245609 | -122.410996073526 | (37.7899465245609, -122.410996073526) | 5 | 1 | 10 | 28857 | 21 | ||
53037 | 129619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1220 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008570.90911 | 2116707.20552 | 37.792558183677 | -122.414270242485 | (37.792558183677, -122.414270242485) | 5 | 1 | 10 | 28857 | 21 | |||
63465 | 96010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.20911 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) | 5 | 1 | 10 | 28857 | 21 |
108182 | 96009 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.90014 | 2116412.09513 | 37.7918121879409 | -122.410284212457 | (37.7918121879409, -122.410284212457) | 5 | 1 | 10 | 28857 | 21 |
108834 | 96008 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.65151 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) | 5 | 1 | 10 | 28857 | 21 |
125787 | 96007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.7917880618207 | -122.410480028126 | (37.7917880618207, -122.410480028126) | 5 | 1 | 10 | 28857 | 21 |
134760 | 37499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010316.35975 | 2115796.38999 | 37.790155194247 | -122.408166630084 | (37.790155194247, -122.408166630084) | 5 | 1 | 10 | 28857 | 6 | |
134917 | 37498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.7901793401628 | -122.408032529472 | (37.7901793401628, -122.408032529472) | 5 | 1 | 10 | 28857 | 6 | |
145386 | 37500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39965 | 6009516.4157 | 2115739.57789 | 37.7899543783457 | -122.410930370855 | (37.7899543783457, -122.410930370855) | 5 | 1 | 10 | 28857 | 21 | |
155856 | 58198 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 920 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1978 12:00:00 AM | 18 | Permit Number 17187 | 6009149.67357 | 2116129.24917 | 37.7910037495643 | -122.412226823621 | (37.7910037495643, -122.412226823621) | 5 | 1 | 10 | 28857 | 21 | ||
158132 | 37497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633 | -122.408090243478 | (37.790172633, -122.408090243478) | 5 | 1 | 10 | 28857 | 6 | |
167090 | 129618 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1220 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008573.01833 | 2116697.29547 | 37.7925310915872 | -122.414262243012 | (37.7925310915872, -122.414262243012) | 5 | 1 | 10 | 28857 | 21 | |||
4457 | 27392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.8016469274247 | -122.419461214785 | (37.8016469274247, -122.419461214785) | 5 | 1 | 1 | 28858 | 32 | |||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
9311 | 71535 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007520.46607 | 2118819.96047 | 37.7983002218264 | -122.418054666102 | (37.7983002218264, -122.418054666102) | 5 | 1 | 10 | 28858 | 32 | |||
14305 | 73447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007557.7828 | 2115066.68598 | 37.7879967592968 | -122.417659373585 | (37.7879967592968, -122.417659373585) | 13 | 1 | 10 | 28858 | 21 | |||
14609 | 70619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | 13 | 1 | 10 | 28858 | 21 | |||
15273 | 249329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 814 Post St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008232.68347 | 2114867.71891 | 37.7874883986038 | -122.415310240102 | (37.7874883986038, -122.415310240102) | 13 | 1 | 10 | 28858 | 21 | |||
16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
18649 | 73588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007504.43189 | 2118817.2788 | 37.7982919561693 | -122.418109959117 | (37.7982919561693, -122.418109959117) | 5 | 1 | 10 | 28858 | 32 | |||
19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
19703 | 129607 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661 | (37.7951095809901, -122.42346356661) | 13 | 9 | 1 | 28858 | 27 | |||
21673 | 129611 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005874.36357 | 2117588.54131 | 37.7948262711743 | -122.423663083898 | (37.7948262711743, -122.423663083898) | 13 | 9 | 1 | 28858 | 27 | |||
25621 | 250098 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006037.70809 | 2115548.99376 | 37.7892354027317 | -122.422952860496 | (37.7892354027317, -122.422952860496) | 13 | 9 | 1 | 28858 | 41 | |||
26118 | 129592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.7939289267389 | -122.42362005315 | (37.7939289267389, -122.42362005315) | 13 | 9 | 1 | 28858 | 27 | |||
28045 | 7974 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005597.93587 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | 13 | 9 | 1 | 28858 | 27 | |||
30495 | 129591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.423523389509 | (37.7939448878875, -122.423523389509) | 13 | 9 | 1 | 28858 | 27 | |||
36625 | 2170 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005396 | 2117789 | 37.7953496659997 | -122.425332561837 | (37.7953496659997, -122.425332561837) | 13 | 9 | 1 | 28858 | 27 | |||
37048 | 129586 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1915 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004232.4663 | 2118008.34749 | 37.795886133905 | -122.429374228549 | (37.795886133905, -122.429374228549) | 13 | 9 | 1 | 28858 | 27 | |||
39094 | 17357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.7949311123398 | -122.42484601254 | (37.7949311123398, -122.42484601254) | 13 | 9 | 1 | 28858 | 27 | |||
40600 | 17748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.423120547185 | (37.7892164261498, -122.423120547185) | 13 | 9 | 1 | 28858 | 41 | |||
41197 | 129600 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005520.4 | 2117740.68195 | 37.7952240242221 | -122.424898677743 | (37.7952240242221, -122.424898677743) | 13 | 9 | 1 | 28858 | 27 | |||
47004 | 129621 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1513 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007498.65921 | 2116790.15789 | 37.792725661708 | -122.417986155759 | (37.792725661708, -122.417986155759) | 5 | 1 | 10 | 28858 | 21 | |||
47447 | 129639 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | 5 | 1 | 1 | 28858 | 32 | |||
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
48624 | 129633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1828 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007334.41691 | 2118641.32283 | 37.7977992544837 | -122.418685778819 | (37.7977992544837, -122.418685778819) | 5 | 1 | 10 | 28858 | 32 |
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) );