trees
7,322 rows where qSpecies_id = 1 sorted by Zip Codes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
| 3015 | 217584 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Randolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5993971.4029 | 2088542.2845 | 37.7143936266554 | -122.462740537778 | (37.7143936266554, -122.462740537778) | 9 | 8 | 6 | 64 | 24 | |||
| 10610 | 218537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 169 Eucalyptus Dr | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5991155.07657 | 2094656.4445 | 37.7310189879395 | -122.472920359789 | (37.7310189879395, -122.472920359789) | 9 | 8 | 4 | 64 | 40 | |||
| 12476 | 78459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2912 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990004.06273 | 2095836.28778 | 37.7341918338916 | -122.476985746011 | (37.7341918338916, -122.476985746011) | 1 | 8 | 4 | 64 | 35 | |||
| 16908 | 218566 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990820.10787 | 2094527.49185 | 37.7306455183576 | -122.474068986495 | (37.7306455183576, -122.474068986495) | 9 | 8 | 4 | 64 | 40 | |||
| 17219 | 25457 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | 9 | 8 | 6 | 64 | 24 | ||
| 17449 | 45532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 91 Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 7 | Permit Number 44291 | 5988299.52892 | 2095312.45705 | 37.732654498611 | -122.482840411668 | (37.732654498611, -122.482840411668) | 1 | 8 | 4 | 64 | 35 | |
| 18585 | 27533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 20086 | 108952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2912 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769302 | 5990002.93775 | 2095864.20098 | 37.7342684111434 | -122.476991674334 | (37.7342684111434, -122.476991674334) | 1 | 8 | 4 | 64 | 35 |
| 20217 | 218570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546 | (37.7305168532543, -122.47426667546) | 9 | 8 | 4 | 64 | 40 | |||
| 20554 | 218572 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 3 | : | Tree | Private 2 | 6 | Width 3ft | 5990712.73892 | 2094463.91628 | 37.7304647357382 | -122.474435535782 | (37.7304647357382, -122.474435535782) | 9 | 8 | 4 | 64 | 40 | |||
| 20919 | 218547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 4 | : | Tree | Private 2 | 6 | Width 3ft | 5991211.41676 | 2094496.23075 | 37.7305823428046 | -122.472713906928 | (37.7305823428046, -122.472713906928) | 9 | 8 | 4 | 64 | 40 | |||
| 21665 | 385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 22771 | 36260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39271 | 5991253.03942343 | 2094450.93126102 | 37.730460371115 | -122.472566711187 | (37.730460371115, -122.472566711187) | 9 | 8 | 4 | 64 | 40 | ||
| 23309 | 266 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 23354 | 218521 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 569 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993243.83162 | 2090944.13294 | 37.7209465926795 | -122.465429665468 | (37.7209465926795, -122.465429665468) | 9 | 8 | 6 | 64 | 24 | |||
| 23523 | 341 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2013 12:00:00 AM | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 26440 | 349 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 27301 | 218583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3674 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 11/07/2015 01:06:00 PM | 3 | Width 3ft | 5990525.76897 | 2091801.92909 | 37.7231447525118 | -122.47488767982 | (37.7231447525118, -122.47488767982) | 9 | 8 | 4 | 64 | 40 | ||
| 27501 | 1231 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3601X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 15 | 3X3 | 5993438.31243 | 2087500.59861 | 37.7115026878867 | -122.464507504506 | (37.7115026878867, -122.464507504506) | 9 | 8 | 4 | 64 | 24 | ||
| 27518 | 218549 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991185.28543 | 2094512.38991 | 37.7306251990928 | -122.472805423756 | (37.7306251990928, -122.472805423756) | 9 | 8 | 4 | 64 | 40 | |||
| 28597 | 218514 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992482.71781 | 2089883.86567 | 37.7179914312497 | -122.467983503544 | (37.7179914312497, -122.467983503544) | 9 | 8 | 6 | 64 | 24 | |||
| 28683 | 217574 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 212 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5993449.9498 | 2088547.5213 | 37.7143779589081 | -122.464543252064 | (37.7143779589081, -122.464543252064) | 9 | 8 | 6 | 64 | 24 | |||
| 30483 | 267 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 30709 | 218559 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990923.4815 | 2094514.63427 | 37.7306162022607 | -122.473710674116 | (37.7306162022607, -122.473710674116) | 9 | 8 | 4 | 64 | 40 | |||
| 31306 | 218523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 506 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993270.87957 | 2090565.64136 | 37.7199089063619 | -122.465308690447 | (37.7199089063619, -122.465308690447) | 9 | 8 | 6 | 64 | 24 | |||
| 32234 | 344 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 2X2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 32685 | 218538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 167 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991172.6444 | 2094656.25325 | 37.7310194798585 | -122.47285961148 | (37.7310194798585, -122.47285961148) | 9 | 8 | 4 | 64 | 40 | |||
| 33770 | 218587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3666 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990534.15112 | 2091988.92412 | 37.7236586799887 | -122.474872347276 | (37.7236586799887, -122.474872347276) | 9 | 8 | 4 | 64 | 40 | |||
| 36112 | 180226 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5989906.43638 | 2095240.30742 | 37.7325497599557 | -122.477279727184 | (37.7325497599557, -122.477279727184) | 1 | 8 | 4 | 64 | 35 | |||
| 36355 | 218565 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Rossmoor Dr | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990819.81522 | 2094485.38355 | 37.7305298826274 | -122.474066927066 | (37.7305298826274, -122.474066927066) | 9 | 8 | 4 | 64 | 40 | |||
| 36862 | 45492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3001 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 7 | Permit Number 44268 | 5989983.22073 | 2095201.5244 | 37.7324477264805 | -122.477011435145 | (37.7324477264805, -122.477011435145) | 1 | 8 | 4 | 64 | 35 | |
| 38174 | 29254 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 40125 | 366 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | |||
| 42576 | 389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 44146 | 218552 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991136.37193 | 2094544.36551 | 37.730710164332 | -122.472976854295 | (37.730710164332, -122.472976854295) | 9 | 8 | 4 | 64 | 40 | |||
| 45088 | 36294 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | |||
| 45299 | 180228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5989943.87272 | 2095241.7603 | 37.7325559212225 | -122.477150408276 | (37.7325559212225, -122.477150408276) | 1 | 8 | 4 | 64 | 35 | |||
| 48964 | 218588 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3658 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990544.88693 | 2092103.53987 | 37.7239740083808 | -122.474843597777 | (37.7239740083808, -122.474843597777) | 9 | 8 | 4 | 64 | 40 | |||
| 50184 | 218597 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3600 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990573.33305 | 2092525.302 | 37.7251337102413 | -122.474776034402 | (37.7251337102413, -122.474776034402) | 9 | 8 | 4 | 64 | 40 | |||
| 50962 | 180222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3602 Alemany Blvd | 5 | : | Tree | Private 2 | 4 | Width 3ft | 5993369.41698 | 2087618.43257 | 37.7118222600726 | -122.464754174762 | (37.7118222600726, -122.464754174762) | 9 | 8 | 4 | 64 | 24 | |||
| 52131 | 218582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3676 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990520.8643 | 2091753.44483 | 37.7230113425852 | -122.474901096806 | (37.7230113425852, -122.474901096806) | 9 | 8 | 4 | 64 | 40 | |||
| 52420 | 218591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3656 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990546.89703 | 2092172.51309 | 37.7241635081101 | -122.47484168131 | (37.7241635081101, -122.47484168131) | 9 | 8 | 4 | 64 | 40 | |||
| 52433 | 343 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 53015 | 45495 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3025 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 5 | Permit Number 44270 | 5989986.35534 | 2095106.40385 | 37.7321867315218 | -122.47699365014 | (37.7321867315218, -122.47699365014) | 1 | 8 | 4 | 64 | 35 | |
| 53126 | 265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 53528 | 406 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3822 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 2x5 | 5990686.03987 | 2090357.61675 | 37.7191883155766 | -122.474228322086 | (37.7191883155766, -122.474228322086) | 9 | 8 | 4 | 64 | 40 | ||
| 53540 | 368 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3690X 19th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/07/2015 01:12:00 PM | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 54865 | 218536 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 169 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991140.50833 | 2094657.00485 | 37.7310196831058 | -122.472970765015 | (37.7310196831058, -122.472970765015) | 9 | 8 | 4 | 64 | 40 | |||
| 55301 | 87582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3438X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 5990574.05576 | 2092494.61094 | 37.725049482144 | -122.47477129702 | (37.725049482144, -122.47477129702) | 9 | 8 | 4 | 64 | 40 | |||
| 55421 | 329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3454X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 56522 | 25461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1998 12:00:00 AM | 3 | 3X3 | 5993284.2782 | 2088548.7908 | 37.7143718926825 | -122.465115966183 | (37.7143718926825, -122.465115966183) | 9 | 8 | 6 | 64 | 24 | ||
| 59744 | 18614 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 645 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1995 12:00:00 AM | 6 | 3X3 | 5992258.4096 | 2088499.5351 | 37.7141774389189 | -122.468658160355 | (37.7141774389189, -122.468658160355) | 9 | 8 | 6 | 64 | 24 | ||
| 60253 | 218556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991013.46606 | 2094544.76676 | 37.7307041496708 | -122.473401783982 | (37.7307041496708, -122.473401783982) | 9 | 8 | 4 | 64 | 40 | |||
| 61303 | 102959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | 9 | 8 | 6 | 64 | 24 | |||
| 61939 | 19342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 509 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5992668.8586 | 2089831.50787 | 37.7178584170188 | -122.467336296546 | (37.7178584170188, -122.467336296546) | 9 | 8 | 6 | 64 | 24 | |||
| 62429 | 218555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Rossmoor Dr | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5991088.47089 | 2094414.70645 | 37.7303513798138 | -122.473133001812 | (37.7303513798138, -122.473133001812) | 9 | 8 | 4 | 64 | 40 | |||
| 62624 | 218580 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3678 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 1 | Width 3ft | 5990518.16488 | 2091704.36213 | 37.7228764172852 | -122.474906847073 | (37.7228764172852, -122.474906847073) | 9 | 8 | 4 | 64 | 40 | ||
| 62814 | 218513 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 234 Ralston St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5992216.02262 | 2089433.07464 | 37.71673826375 | -122.468872558017 | (37.71673826375, -122.468872558017) | 9 | 8 | 6 | 64 | 24 | |||
| 63158 | 218576 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3696 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 1 | Width 3ft | 5990496.40518 | 2091356.42271 | 37.7219198012285 | -122.474956679412 | (37.7219198012285, -122.474956679412) | 9 | 8 | 4 | 64 | 40 | ||
| 64693 | 218519 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 313 Vernon St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992450.27493 | 2089919.88933 | 37.7180884698913 | -122.468098262426 | (37.7180884698913, -122.468098262426) | 9 | 8 | 6 | 64 | 24 | |||
| 65137 | 96867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 620 Palmetto Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991882.45781 | 2087240.6995 | 37.7106992550313 | -122.469865986023 | (37.7106992550313, -122.469865986023) | 9 | 8 | 4 | 64 | 24 | |||
| 65360 | 218517 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 5992480.50725 | 2089942.05424 | 37.7181510752812 | -122.46799537461 | (37.7181510752812, -122.46799537461) | 9 | 8 | 6 | 64 | 24 | |||
| 65504 | 218567 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Rossmoor Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990805.65582 | 2094520.08565 | 37.7306243456255 | -122.474118408742 | (37.7306243456255, -122.474118408742) | 9 | 8 | 4 | 64 | 40 | |||
| 65733 | 36265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.7307300237066 | -122.473310148521 | (37.7307300237066, -122.473310148521) | 9 | 8 | 4 | 64 | 40 | |||
| 65998 | 218596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3648 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990560.74644 | 2092329.57586 | 37.7245955658112 | -122.47480526506 | (37.7245955658112, -122.47480526506) | 9 | 8 | 4 | 64 | 40 | |||
| 67232 | 256000 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Springfield Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2018 12:00:00 AM | 3 | 6x10 | Permit Number 780036 | 5986792.13129 | 2095812.03329 | 37.733938381975 | -122.488088482457 | (37.733938381975, -122.488088482457) | 1 | 8 | 4 | 64 | 35 | |
| 69343 | 180232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990560.88116 | 2094301.12061 | 37.7300089404634 | -122.47494864576 | (37.7300089404634, -122.47494864576) | 1 | 8 | 4 | 64 | 14 | |||
| 70879 | 387 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 71179 | 19339 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 432 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/1994 12:00:00 AM | 6 | 3X3 | 5992829.9763 | 2089860.08955 | 37.7179461953347 | -122.466781465212 | (37.7179461953347, -122.466781465212) | 9 | 8 | 6 | 64 | 24 | ||
| 71529 | 255511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 638 Head St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 6x15 | 5993525.36191 | 2090091.06114 | 37.7186204962068 | -122.464394601529 | (37.7186204962068, -122.464394601529) | 9 | 8 | 6 | 64 | 24 | |||
| 72040 | 384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 73446 | 399 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3790X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990543.5477982 | 2090571.3277717 | 37.7197668572984 | -122.474736447703 | (37.7197668572984, -122.474736447703) | 9 | 8 | 4 | 64 | 40 | ||
| 74270 | 218525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Bright St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5993735.162 | 2088577.56083 | 37.7144768779817 | -122.463559632267 | (37.7144768779817, -122.463559632267) | 9 | 8 | 6 | 64 | 24 | |||
| 75519 | 218600 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3580 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990590.55641 | 2092887.14318 | 37.7261282336098 | -122.474742893484 | (37.7261282336098, -122.474742893484) | 9 | 8 | 4 | 64 | 40 | |||
| 76361 | 45491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3001 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 6 | Permit Number 44268 | 5989982.91393 | 2095214.05279 | 37.7324821084495 | -122.477013410953 | (37.7324821084495, -122.477013410953) | 1 | 8 | 4 | 64 | 35 | |
| 77622 | 351 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 78241 | 36295 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | 9 | 8 | 4 | 64 | 40 | |||
| 78571 | 218531 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 179 Eucalyptus Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 5990912.64325 | 2094665.20495 | 37.731029003689 | -122.473759123306 | (37.731029003689, -122.473759123306) | 9 | 8 | 4 | 64 | 40 | |||
| 78644 | 36256 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
| 79586 | 32179 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35514 | 5984280.14048735 | 2094205.11731478 | 37.7293793539098 | -122.496654523481 | (37.7293793539098, -122.496654523481) | 1 | 8 | 4 | 64 | 35 | ||
| 79655 | 217575 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5993402.0257 | 2088548.4734 | 37.7143778103192 | -122.464708964488 | (37.7143778103192, -122.464708964488) | 9 | 8 | 6 | 64 | 24 | |||
| 80366 | 180223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3602 Alemany Blvd | 8 | : | Tree | Private 2 | 6 | Width 3ft | 5993236.04296 | 2087638.25257 | 37.7118689906411 | -122.465216587281 | (37.7118689906411, -122.465216587281) | 9 | 8 | 4 | 64 | 24 | |||
| 82429 | 36278 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39278 | 5991022.47129898 | 2094553.69914368 | 37.7307291972141 | -122.473371303037 | (37.7307291972141, -122.473371303037) | 9 | 8 | 4 | 64 | 40 | |||
| 82791 | 218562 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990887.70773 | 2094513.01623 | 37.7306096875755 | -122.473834230193 | (37.7306096875755, -122.473834230193) | 9 | 8 | 4 | 64 | 40 | |||
| 84661 | 36283 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39280 | 5990920.84116695 | 2094554.1128949 | 37.7307244477014 | -122.47372268091 | (37.7307244477014, -122.47372268091) | 9 | 8 | 4 | 64 | 40 | |||
| 84913 | 180233 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5990560.21445 | 2094269.53269 | 37.7299221693679 | -122.474948645772 | (37.7299221693679, -122.474948645772) | 1 | 8 | 4 | 64 | 14 | |||
| 84917 | 36255 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
| 85749 | 1216 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3501 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2000 12:00:00 AM | 8 | 3X3 | 5993668.38843 | 2087432.77384 | 37.711329717576 | -122.4637073882 | (37.711329717576, -122.4637073882) | 9 | 8 | 4 | 64 | 24 | ||
| 86767 | 218585 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3668 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990532.46712 | 2091935.40321 | 37.7235116273307 | -122.474874263756 | (37.7235116273307, -122.474874263756) | 9 | 8 | 4 | 64 | 40 | |||
| 86859 | 32182 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 187 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35515 | 5984242.60551895 | 2094230.34339508 | 37.7294464187928 | -122.496786144383 | (37.7294464187928, -122.496786144383) | 1 | 8 | 4 | 64 | 35 | ||
| 87235 | 338 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1999 12:00:00 AM | 2 | 5990537.6838371 | 2091850.0721832 | 37.723277631918 | -122.474850005229 | (37.723277631918, -122.474850005229) | 9 | 8 | 4 | 64 | 40 | |||
| 88415 | 36280 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1998 12:00:00 AM | Permit Number 39278 | 5991022.47129898 | 2094553.69914368 | 37.7307291972141 | -122.473371303037 | (37.7307291972141, -122.473371303037) | 9 | 8 | 4 | 64 | 40 | |||
| 88848 | 217582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 136 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5993589.4377 | 2088544.8235 | 37.7143785915552 | -122.464060934754 | (37.7143785915552, -122.464060934754) | 9 | 8 | 6 | 64 | 24 | |||
| 89767 | 218545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991243.29595 | 2094455.32359 | 37.7304718673622 | -122.472600715558 | (37.7304718673622, -122.472600715558) | 9 | 8 | 4 | 64 | 40 | |||
| 90683 | 180229 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990564.52404 | 2094381.66097 | 37.7302302950786 | -122.474941928742 | (37.7302302950786, -122.474941928742) | 1 | 8 | 4 | 64 | 14 | |||
| 92663 | 218524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Bright St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993735.17777 | 2088595.3117 | 37.7145256185467 | -122.463560865244 | (37.7145256185467, -122.463560865244) | 9 | 8 | 6 | 64 | 24 | |||
| 92729 | 218534 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991093.98994 | 2094659.29915 | 37.731023289396 | -122.47313175264 | (37.731023289396, -122.47313175264) | 9 | 8 | 4 | 64 | 40 | |||
| 93086 | 218553 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991104.11114 | 2094544.62455 | 37.7307090078018 | -122.473088402633 | (37.7307090078018, -122.473088402633) | 9 | 8 | 4 | 64 | 40 | |||
| 93843 | 44737 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.47858 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | 9 | 8 | 4 | 64 | 24 |
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) );