trees
8,659 rows where qSpecies_id = 11 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
1690 | 52430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2536 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 12 | Permit Number 48545 | 6002701.73302 | 2117006.28973 | 37.7930479607542 | -122.434599161948 | (37.7930479607542, -122.434599161948) | 13 | 9 | 1 | 29490 | 27 | |
1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
1924 | 96221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 3 | 3x3 | 6006663 | 2110979.9 | 37.7767250501872 | -122.420464968339 | (37.7767250501872, -122.420464968339) | 7 | 9 | 11 | 28852 | 10 | ||
2484 | 20118 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 875X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 12 | 2X2 | 6003233.15229 | 2110304.12624 | 37.774675660821 | -122.432281545934 | (37.774675660821, -122.432281545934) | 15 | 9 | 11 | 29492 | 10 | ||
2630 | 47383 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1515 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | Permit Number 46367 | 6006307.07862293 | 2118296.63950756 | 37.7967949468883 | -122.422216159163 | (37.7967949468883, -122.422216159163) | 13 | 9 | 10 | 28858 | 32 | |||
2709 | 140325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.427951167196 | (37.7844794061151, -122.427951167196) | 13 | 9 | 11 | 29490 | 41 | |||
3240 | 23833 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1302X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 3 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | ||
3616 | 7957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.7912122663809 | -122.424102272302 | (37.7912122663809, -122.424102272302) | 13 | 9 | 1 | 28858 | 27 | ||
4353 | 6174 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | ||
4428 | 66790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2150 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53367 | 6006860.21214417 | 2118575.27175394 | 37.79759118503 | -122.420321971868 | (37.79759118503, -122.420321971868) | 5 | 9 | 10 | 28858 | 32 | ||
4532 | 70356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.421362640608 | (37.7943758388735, -122.421362640608) | 13 | 9 | 10 | 28858 | 32 | |||
4632 | 143126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2055 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002559.0217 | 2119480.0502 | 37.7998321621177 | -122.435269976592 | (37.7998321621177, -122.435269976592) | 13 | 9 | 1 | 57 | 17 | |||
4844 | 228872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 4x7 | Permit Number 781830 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.429273464001 | (37.7698314611737, -122.429273464001) | 7 | 9 | 5 | 29492 | 10 | |
4915 | 26860 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1483 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 3 | 3X3 | 6005670.64359 | 2114807.23754 | 37.7871780057048 | -122.424170086605 | (37.7871780057048, -122.424170086605) | 13 | 9 | 1 | 28858 | 41 | ||
4947 | 6953 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 609 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004373.4958 | 2110460.1271 | 37.7751685930556 | -122.428347988839 | (37.7751685930556, -122.428347988839) | 7 | 9 | 11 | 28852 | 10 | ||
5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
5686 | 129917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 506 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004089.66416 | 2110540.0338 | 37.7753719324971 | -122.429335525339 | (37.7753719324971, -122.429335525339) | 7 | 9 | 11 | 28852 | 10 | |||
5899 | 228878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 317 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004644.50049 | 2109700.89583 | 37.7730992602639 | -122.427356425982 | (37.7730992602639, -122.427356425982) | 7 | 9 | 11 | 28852 | 10 | |||
5920 | 4544 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Cleary Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
5944 | 130091 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 740 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005787.47808 | 2112322.76962 | 37.780362864998 | -122.423589158734 | (37.780362864998, -122.423589158734) | 7 | 9 | 11 | 28852 | 41 | |||
6287 | 6206 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1155 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005354.90901 | 2113296.39872 | 37.7830117847389 | -122.425154916389 | (37.7830117847389, -122.425154916389) | 7 | 9 | 11 | 28858 | 41 | |||
6830 | 260679 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
7107 | 9706 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6005904.98118 | 2111477.12508 | 37.7780475630877 | -122.423122534696 | (37.7780475630877, -122.423122534696) | 7 | 9 | 11 | 28852 | 10 | |||
7339 | 130136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 520 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005895.11777 | 2111561.87287 | 37.7782797032844 | -122.423162681334 | (37.7782797032844, -122.423162681334) | 7 | 9 | 11 | 28852 | 10 | |||
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
7548 | 6171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1075 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
7555 | 69133 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1624 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 18 | Permit Number 33160 | 6006948.32504 | 2116425.19331 | 37.7916925709073 | -122.419864429405 | (37.7916925709073, -122.419864429405) | 13 | 9 | 10 | 28858 | 21 | |
7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
7718 | 129913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 514 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004072.23496 | 2110659.68324 | 37.7756994736965 | -122.429404351323 | (37.7756994736965, -122.429404351323) | 7 | 9 | 11 | 28852 | 10 | |||
7955 | 6258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1338X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2010 12:00:00 AM | 3 | 3X3 | 6004383.57489 | 2113288.83653 | 37.7829361010006 | -122.428514794701 | (37.7829361010006, -122.428514794701) | 7 | 9 | 11 | 29490 | 41 | ||
7967 | 130244 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2041 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006851.67762 | 2118267.24784 | 37.7967449477794 | -122.420329629819 | (37.7967449477794, -122.420329629819) | 13 | 9 | 10 | 28858 | 32 | |||
7977 | 63890 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 165 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24599 | 6005777.74997654 | 2109961.71011831 | 37.7738794203064 | -122.423454911884 | (37.7738794203064, -122.423454911884) | 7 | 9 | 11 | 28852 | 10 | ||
8182 | 130186 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005950.50335 | 2111126.42384 | 37.7770871914573 | -122.422940125193 | (37.7770871914573, -122.422940125193) | 7 | 9 | 11 | 28852 | 10 | |||
8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
8972 | 23214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006727.4886023 | 2112541.6876005 | 37.7810169750537 | -122.42035276087 | (37.7810169750537, -122.42035276087) | 7 | 9 | 9 | 28852 | 36 | ||
9026 | 23835 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1302X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1990 12:00:00 AM | 20 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | ||
9181 | 26766 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6006110.12347 | 2115558.4451 | 37.7892654396548 | -122.422702983606 | (37.7892654396548, -122.422702983606) | 13 | 9 | 1 | 28858 | 41 | |||
9313 | 129991 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1020 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005653.15394 | 2113299.68835 | 37.7830376609932 | -122.42412334433 | (37.7830376609932, -122.42412334433) | 7 | 9 | 11 | 28858 | 41 | |||
9369 | 130083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 633 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 11:15:00 AM | 2 | Width 4ft | 6006236.08792 | 2112182.41564 | 37.7800027989227 | -122.422027232369 | (37.7800027989227, -122.422027232369) | 7 | 9 | 11 | 28852 | 41 | ||
9678 | 257993 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1299x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004575 | 2113275 | 37.7829089401984 | -122.427851556708 | (37.7829089401984, -122.427851556708) | 7 | 9 | 11 | 29490 | 41 | ||||
9704 | 13240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2346 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774035 | 6001131.9237 | 2119364.2962 | 37.7994331868979 | -122.440199950322 | (37.7994331868979, -122.440199950322) | 13 | 9 | 1 | 57 | 17 | |
9706 | 260678 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
9875 | 23182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006776.0786915 | 2112192.9314348 | 37.7800621132124 | -122.42015990463 | (37.7800621132124, -122.42015990463) | 7 | 9 | 9 | 28852 | 36 | ||
10068 | 49666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | 13 | 9 | 1 | 57 | 17 | ||
10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
10415 | 43967 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43534 | 6006999.24602912 | 2112908.87547401 | 37.7820404937398 | -122.419438672428 | (37.7820404937398, -122.419438672428) | 7 | 9 | 9 | 28852 | 36 | |||
10590 | 13232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2301 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 10 | 3X3 | 6001301 | 2119283 | 37.7992195934801 | -122.439609056557 | (37.7992195934801, -122.439609056557) | 13 | 9 | 1 | 57 | 17 | ||
10649 | 76037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
10746 | 130121 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 711 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6006217.81711 | 2112104.31895 | 37.7797873339463 | -122.422084889732 | (37.7797873339463, -122.422084889732) | 7 | 9 | 11 | 28852 | 10 | |||
10777 | 35244 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
10853 | 14629 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 580 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6006423.31397 | 2112182.40692 | 37.7800133326755 | -122.42137953166 | (37.7800133326755, -122.42137953166) | 7 | 9 | 11 | 28852 | 41 | |||
10962 | 39426 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.7733943405421 | -122.42743561187 | (37.7733943405421, -122.42743561187) | 7 | 9 | 11 | 28852 | 10 | |||
11081 | 17829 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1955 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004588.8583705 | 2115348.8927865 | 37.7886041154805 | -122.427951442059 | (37.7886041154805, -122.427951442059) | 13 | 9 | 11 | 28858 | 27 | |||
11195 | 110472 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542 | 2111298 | 37.7775352389463 | -122.424365474196 | (37.7775352389463, -122.424365474196) | 7 | 9 | 11 | 28852 | 10 | ||
11612 | 65947 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1005 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 11 | Permit Number 28968 | 6007327.06617 | 2114853.5126 | 37.7873984520186 | -122.418442492445 | (37.7873984520186, -122.418442492445) | 13 | 9 | 10 | 28858 | 21 | |
11789 | 130145 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2017 12:00:00 AM | 3 | Width 4ft | 6005854.49037 | 2111843.71105 | 37.7790512694499 | -122.42332326697 | (37.7790512694499, -122.42332326697) | 7 | 9 | 11 | 28852 | 10 | ||
12038 | 50316 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1055 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
12085 | 9686 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6005996.09112 | 2110833.49174 | 37.7762854431535 | -122.422761599875 | (37.7762854431535, -122.422761599875) | 7 | 9 | 11 | 28852 | 10 | |||
12710 | 130149 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006347.46727 | 2111403.63239 | 37.7778707302976 | -122.421586593341 | (37.7778707302976, -122.421586593341) | 7 | 9 | 11 | 28852 | 10 | |||
12889 | 48521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
13320 | 130154 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 155 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006852.76549 | 2111067.6012 | 37.7769765487554 | -122.419814736462 | (37.7769765487554, -122.419814736462) | 7 | 9 | 11 | 28852 | 10 | |||
13372 | 249467 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6006503.72956 | 2113992.67034 | 37.7849884074321 | -122.421229920427 | (37.7849884074321, -122.421229920427) | 13 | 9 | 11 | 28858 | 36 | |||
13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
13480 | 26768 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006153.01253 | 2115563.98266 | 37.7892830640976 | -122.42255498602 | (37.7892830640976, -122.42255498602) | 13 | 9 | 1 | 28858 | 41 | |||
13562 | 73666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 725 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007366.22469 | 2113649.85624 | 37.7840957097951 | -122.418221641431 | (37.7840957097951, -122.418221641431) | 7 | 9 | 9 | 28858 | 36 | |||
13704 | 9704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6005878.26798 | 2111295.24256 | 37.7775466504055 | -122.423202013315 | (37.7775466504055, -122.423202013315) | 7 | 9 | 11 | 28852 | 10 | ||
14068 | 13261 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6000701.59201 | 2119217.25602 | 37.7990049442386 | -122.441678488129 | (37.7990049442386, -122.441678488129) | 13 | 9 | 1 | 57 | 17 | ||
14092 | 23172 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 214 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006926.9126711 | 2111261.9734357 | 37.7775144249112 | -122.419572031751 | (37.7775144249112, -122.419572031751) | 7 | 9 | 9 | 28852 | 36 | |||
14102 | 10249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 115 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 20 | 3X3 | 6005554.00593 | 2109582.93221 | 37.7728267566811 | -122.424201936088 | (37.7728267566811, -122.424201936088) | 7 | 9 | 11 | 28852 | 10 | ||
14651 | 260677 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601x McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006263 | 2112118 | 37.7798274470499 | -122.421929554146 | (37.7798274470499, -122.421929554146) | 7 | 9 | 11 | 28852 | 10 | ||||
14875 | 130179 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006655.87102 | 2110834.54234 | 37.7763255313215 | -122.420479309383 | (37.7763255313215, -122.420479309383) | 7 | 9 | 11 | 28852 | 10 | |||
15004 | 82837 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 604 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004044.4214 | 2110838.57135 | 37.7761890816952 | -122.429513325784 | (37.7761890816952, -122.429513325784) | 7 | 9 | 11 | 28852 | 10 | |||
15034 | 140327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1435 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004568.4782 | 2113773.262 | 37.7842766747196 | -122.427909635375 | (37.7842766747196, -122.427909635375) | 13 | 9 | 11 | 29490 | 41 | |||
15243 | 98997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | ||||
15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
15593 | 130235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005988.60064 | 2120959.86285 | 37.8040895112914 | -122.42350760369 | (37.8040895112914, -122.42350760369) | 5 | 9 | 1 | 28858 | 32 | |||
15954 | 79175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005975.99544 | 2111376.30995 | 37.777774756444 | -122.422869703793 | (37.777774756444, -122.422869703793) | 7 | 9 | 11 | 28852 | 10 | |||
16121 | 130125 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006275.72072 | 2111955.4764 | 37.7793819141766 | -122.421873999612 | (37.7793819141766, -122.421873999612) | 7 | 9 | 11 | 28852 | 10 | |||
16378 | 261659 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2401 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000878 | 2119196 | 37.7989566302666 | -122.441066533327 | (37.7989566302666, -122.441066533327) | 13 | 9 | 1 | 57 | 17 | ||||
16602 | 257992 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1299x Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004575 | 2113275 | 37.7829089401984 | -122.427851556708 | (37.7829089401984, -122.427851556708) | 7 | 9 | 11 | 29490 | 41 | ||||
16642 | 98248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.49549 | 2113344.84788 | 37.7832534614285 | -122.41849313956 | (37.7832534614285, -122.41849313956) | 7 | 9 | 9 | 28858 | 36 | |
16686 | 99005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
16711 | 249324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007004.56067 | 2110712.36336 | 37.7760097011293 | -122.419264423336 | (37.7760097011293, -122.419264423336) | 7 | 9 | 9 | 28852 | 36 | |||
16728 | 7806 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 699X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767203 | 6006206.38282 | 2112399.17738 | 37.780596298426 | -122.422145399717 | (37.780596298426, -122.422145399717) | 7 | 9 | 11 | 28852 | 41 | |
16745 | 32715 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1105 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 6 | Permit Number 37110 | 6007284.26243 | 2115178.29888 | 37.7882878257567 | -122.418613625325 | (37.7882878257567, -122.418613625325) | 13 | 9 | 10 | 28858 | 21 | |
16777 | 228898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Haight St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005584.45074 | 2109588.27771 | 37.7728431531072 | -122.424097004096 | (37.7728431531072, -122.424097004096) | 7 | 9 | 11 | 28852 | 10 | |||
17428 | 66289 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1550 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1990 12:00:00 AM | 14 | Permit Number 29400 | 6006784.05132 | 2117383.92877 | 37.7943157638115 | -122.420500900308 | (37.7943157638115, -122.420500900308) | 13 | 9 | 10 | 28858 | 32 | |
17539 | 9421 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.422598636412 | (37.7806825946662, -122.422598636412) | 7 | 9 | 11 | 28852 | 41 | |
17583 | 6884 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 259 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6006188.5681 | 2110693.92394 | 37.7759130816021 | -122.422085850442 | (37.7759130816021, -122.422085850442) | 7 | 9 | 11 | 28852 | 10 |
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) );