trees
136 rows where SiteOrder = 2 and qSpecies_id = 5 sorted by Latitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154770 | 47240 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1006X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013969.3769 | 2089681.5637 | 37.7186533627648 | -122.393698770823 | (37.7186533627648, -122.393698770823) | 10 | 3 | 8 | 58 | 1 |
49549 | 13332 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011384.17484 | 2090567.17856 | 37.7209410845847 | -122.402697063866 | (37.7209410845847, -122.402697063866) | 10 | 7 | 8 | 309 | 28 | |||
100972 | 199697 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | 10 | 3 | 8 | 58 | 1 | |||
170432 | 199692 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | 10 | 3 | 8 | 58 | 1 | |||
149414 | 205991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.7284735045328 | -122.465126926677 | (37.7284735045328, -122.465126926677) | 9 | 8 | 4 | 59 | 40 | |||
179167 | 206017 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 59 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996580.00391 | 2094034.75678 | 37.7296245567167 | -122.454120687124 | (37.7296245567167, -122.454120687124) | 9 | 7 | 4 | 28861 | 40 | |||
38322 | 206016 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | |||
132285 | 94893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
117426 | 17378 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1600 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6014792.92868 | 2095354.29337 | 37.7342752738796 | -122.391248382303 | (37.7342752738796, -122.391248382303) | 10 | 3 | 8 | 58 | 1 | |||
168615 | 4389 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | ||
174999 | 205996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.7365620951723 | -122.446546561796 | (37.7365620951723, -122.446546561796) | 9 | 7 | 4 | 59 | 40 | |||
6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
21860 | 206006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | 1 | 8 | 4 | 29491 | 40 | |||
153332 | 96855 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007257 | 2097738 | 37.740399305054 | -122.417471450766 | (37.740399305054, -122.417471450766) | 2 | 7 | 7 | 28859 | 2 | |||
8477 | 224897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007276.43224 | 2097752.07019 | 37.7404390320343 | -122.417405258456 | (37.7404390320343, -122.417405258456) | 2 | 7 | 7 | 28859 | 2 | |||
8125 | 189865 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.387293751216 | (37.7410155838051, -122.387293751216) | 10 | 3 | 8 | 58 | 1 | |||
166537 | 6646 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1990 12:00:00 AM | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | ||
111910 | 189867 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6016089.46635 | 2097928.70806 | 37.7414159637784 | -122.38694528192 | (37.7414159637784, -122.38694528192) | 10 | 3 | 8 | 58 | 1 | |||
168028 | 16541 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | 10 | 3 | 8 | 58 | 1 | |||
21523 | 189852 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Newhall St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586949 | (37.7420414890213, -122.38254586949) | 10 | 3 | 8 | 58 | 1 | |||
43304 | 14908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017351.5544479 | 2098138.8848753 | 37.7420628687633 | -122.382595996286 | (37.7420628687633, -122.382595996286) | 10 | 3 | 8 | 58 | 1 | |||
113438 | 16522 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016298.51131 | 2098203.01239 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | 10 | 3 | 8 | 58 | 1 | |||
184901 | 189840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6017094.37686 | 2098212.93845 | 37.7422519942486 | -122.383490397763 | (37.7422519942486, -122.383490397763) | 10 | 3 | 8 | 58 | 1 | |||
164425 | 4913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
109930 | 16491 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016683.07088 | 2098298.50072 | 37.7424641896573 | -122.384918540359 | (37.7424641896573, -122.384918540359) | 10 | 3 | 8 | 58 | 1 | |||
124439 | 189888 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6016891.26784 | 2098307.49665 | 37.7425004040788 | -122.384199276697 | (37.7425004040788, -122.384199276697) | 10 | 3 | 8 | 58 | 1 | |||
102749 | 16480 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
102361 | 189877 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016448.85629 | 2098333.07564 | 37.7425461678608 | -122.385730801451 | (37.7425461678608, -122.385730801451) | 10 | 3 | 8 | 58 | 1 | |||
100676 | 16500 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
21954 | 189895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016704.91422 | 2098345.41637 | 37.7425942186412 | -122.384846279543 | (37.7425942186412, -122.384846279543) | 10 | 3 | 8 | 58 | 1 | |||
190306 | 93110 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.54888 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | 10 | 3 | 8 | 58 | 1 | |
75654 | 189902 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | |||
48636 | 16511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016438.27303 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | 10 | 3 | 8 | 58 | 1 | |||
57622 | 14925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
114352 | 248264 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006711.60121 | 2098736.37276 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | 2 | 7 | 7 | 28859 | 2 | |||
32244 | 111887 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
193801 | 248275 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.53211 | 2098758.77008 | 37.743173713897 | -122.419288098893 | (37.743173713897, -122.419288098893) | 2 | 7 | 7 | 28859 | 2 | |||
75130 | 248258 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006769.18682 | 2098841.93634 | 37.7434030077589 | -122.419236409442 | (37.7434030077589, -122.419236409442) | 2 | 7 | 7 | 28859 | 2 | |||
177859 | 248254 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | 2 | 7 | 7 | 28859 | 2 | |||
149041 | 113693 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 112 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6006814 | 2098928 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | 2 | 7 | 7 | 28859 | 2 | ||||
175245 | 2498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016761.82696 | 2098799.80324 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | 10 | 3 | 8 | 58 | 1 | |||
83815 | 248196 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.418790137961 | (37.7439480508589, -122.418790137961) | 2 | 7 | 7 | 28859 | 2 | |||
68290 | 57557 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 88 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16422 | 6006885 | 2099070 | 37.7440357411005 | -122.418852127392 | (37.7440357411005, -122.418852127392) | 2 | 7 | 7 | 28859 | 2 | |
71087 | 189833 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 2 | : | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | 10 | 3 | 8 | 58 | 1 | ||
48025 | 248201 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.418633720666 | (37.7441794671077, -122.418633720666) | 2 | 7 | 7 | 28859 | 2 | |||
120474 | 2514 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | 10 | 3 | 8 | 58 | 1 | |||
153552 | 248204 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006982.89792 | 2099182.49751 | 37.7443501458548 | -122.418521593214 | (37.7443501458548, -122.418521593214) | 2 | 7 | 7 | 28859 | 2 | |||
79778 | 2524 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449 | 2099041 | 37.7444899913278 | -122.385779635787 | (37.7444899913278, -122.385779635787) | 10 | 3 | 8 | 58 | 1 | ||
124051 | 248207 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007026.81239 | 2099268.29908 | 37.7445882098712 | -122.418375828376 | (37.7445882098712, -122.418375828376) | 2 | 7 | 7 | 28859 | 2 | |||
180800 | 248209 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 37 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007043.43628 | 2099296.21325 | 37.7446657917085 | -122.418320324941 | (37.7446657917085, -122.418320324941) | 2 | 7 | 7 | 28859 | 2 | |||
85869 | 2534 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.7446815361299 | -122.386659150015 | (37.7446815361299, -122.386659150015) | 10 | 3 | 8 | 58 | 1 | |||
33787 | 2545 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1590X Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6016148.3291237 | 2099227.8294693 | 37.7449863439757 | -122.386832330586 | (37.7449863439757, -122.386832330586) | 10 | 3 | 8 | 58 | 1 | ||
111983 | 206019 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.7450917681756 | -122.460627918846 | (37.7450917681756, -122.460627918846) | 1 | 8 | 4 | 59 | 40 | |||
188809 | 218314 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | 1 | 8 | 4 | 29491 | 40 | |||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
91647 | 205994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994253.11993 | 2101023.44894 | 37.7486800649323 | -122.462671676761 | (37.7486800649323, -122.462671676761) | 1 | 8 | 4 | 29491 | 40 | |||
161171 | 113383 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5994461 | 2101055 | 37.7487786662853 | -122.461955122224 | (37.7487786662853, -122.461955122224) | 1 | 8 | 4 | 29491 | 40 | |||
29270 | 103687 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 903 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6008052 | 2102672 | 37.7539916655216 | -122.415071798268 | (37.7539916655216, -122.415071798268) | 2 | 4 | 7 | 28859 | 19 | |||
21283 | 225084 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.431927750974 | (37.7547027131682, -122.431927750974) | 2 | 4 | 5 | 28862 | 22 | |||
149886 | 5523 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.7556899313628 | -122.425382766602 | (37.7556899313628, -122.425382766602) | 2 | 4 | 5 | 28859 | 19 | |||
101361 | 222898 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6009527.7031 | 2103333.93064 | 37.7558919964247 | -122.410015170384 | (37.7558919964247, -122.410015170384) | 2 | 4 | 7 | 28859 | 19 | |||
27880 | 438 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 792X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6 | 6004975.0011312 | 2103729.1085203 | 37.7567208435744 | -122.425788038834 | (37.7567208435744, -122.425788038834) | 2 | 4 | 5 | 28862 | 3 | |||
99119 | 50383 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
115384 | 225080 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2823 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009082.12028 | 2103902.99509 | 37.7574295349581 | -122.411596352099 | (37.7574295349581, -122.411596352099) | 2 | 4 | 7 | 28859 | 19 | |||
43272 | 105450 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | 2 | 4 | 7 | 28859 | 19 | |||||
64795 | 225045 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 881 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009145.12233 | 2103987.25914 | 37.7576644387915 | -122.411384417877 | (37.7576644387915, -122.411384417877) | 2 | 4 | 7 | 28859 | 19 | |||
149591 | 206002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.7580697533422 | -122.471665566332 | (37.7580697533422, -122.471665566332) | 1 | 8 | 4 | 56 | 12 | |||
110855 | 114592 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991433 | 2104626 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | 1 | 8 | 4 | 56 | 12 | |||
185043 | 48532 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
148016 | 222902 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010304.7702 | 2105067.63235 | 37.760695874438 | -122.407450027813 | (37.760695874438, -122.407450027813) | 10 | 4 | 8 | 28859 | 19 | |||
161298 | 47317 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | 10 | 4 | 8 | 28859 | 19 | |||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
77410 | 188477 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 San Bruno Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6010894.54885 | 2106022.42438 | 37.7633505121307 | -122.405477483603 | (37.7633505121307, -122.405477483603) | 8 | 4 | 8 | 28856 | 19 | |||
52442 | 188480 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 209 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012920.54855 | 2106035.89651 | 37.7635005775036 | -122.398471110175 | (37.7635005775036, -122.398471110175) | 14 | 3 | 8 | 28856 | 29 | |||
16559 | 222925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.7635624787486 | -122.447245077795 | (37.7635624787486, -122.447245077795) | 15 | 5 | 11 | 29492 | 9 | |||
85587 | 94581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998825 | 2106371 | 37.763625362932 | -122.447247037522 | (37.763625362932, -122.447247037522) | 15 | 5 | 11 | 29492 | 9 | ||||
77058 | 222893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | 8 | 4 | 5 | 28859 | 19 | |||
182657 | 5384 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
25898 | 225060 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.7643520771977 | -122.453277577199 | (37.7643520771977, -122.453277577199) | 15 | 5 | 11 | 29492 | 12 | |||
171993 | 225042 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999193.16537 | 2106656.55415 | 37.7644304531311 | -122.445994213458 | (37.7644304531311, -122.445994213458) | 15 | 5 | 11 | 29492 | 9 | |||
145445 | 222923 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 88 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998162.74598 | 2106870.63901 | 37.7649593821837 | -122.449573561064 | (37.7649593821837, -122.449573561064) | 15 | 5 | 11 | 29492 | 9 | |||
18852 | 222928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.7649616790718 | -122.447513315894 | (37.7649616790718, -122.447513315894) | 15 | 5 | 11 | 29492 | 9 | |||
69905 | 222921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.449866104246 | (37.7649946607859, -122.449866104246) | 15 | 5 | 11 | 29492 | 9 | |||
169536 | 222895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.09401 | 37.7650176483701 | -122.421511125848 | (37.7650176483701, -122.421511125848) | 8 | 4 | 7 | 28853 | 19 | ||
62803 | 189959 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010397.61848 | 2108539.03358 | 37.7702327485634 | -122.40737363759 | (37.7702327485634, -122.40737363759) | 8 | 2 | 9 | 28853 | 34 | |||
187922 | 10409 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5999436 | 2108778 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | 15 | 5 | 11 | 29492 | 9 | |||
127110 | 103340 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 772809 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | ||
183287 | 188468 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | 8 | 2 | 9 | 28853 | 19 | |||
108228 | 225097 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6004333.63591 | 2109116.41234 | 37.7714768248196 | -122.42839007974 | (37.7714768248196, -122.42839007974) | 7 | 9 | 11 | 28852 | 10 | |||
98842 | 22886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
107019 | 225101 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.422467246366 | (37.7721720124675, -122.422467246366) | 8 | 2 | 9 | 28853 | 19 | |||
50010 | 85052 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 355x Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | 7 | 9 | 11 | 28852 | 10 | |||
71893 | 189957 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.7733037049339 | -122.403694422077 | (37.7733037049339, -122.403694422077) | 14 | 2 | 9 | 28853 | 34 | |||
116588 | 222905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004739.78961 | 2109820.49268 | 37.7734330328342 | -122.427035328438 | (37.7734330328342, -122.427035328438) | 7 | 9 | 11 | 28852 | 10 | |||
68954 | 7418 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.7769504410171 | -122.407735574616 | (37.7769504410171, -122.407735574616) | 14 | 2 | 9 | 28853 | 34 | |||
57482 | 140579 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.431800729752 | (37.7783626547096, -122.431800729752) | 15 | 9 | 11 | 29492 | 41 | |||
36977 | 14687 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
24753 | 140022 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005467.685 | 2112000.1843 | 37.7794590687234 | -122.424672518677 | (37.7794590687234, -122.424672518677) | 7 | 9 | 11 | 28852 | 41 |
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) );