trees
3,965 rows where qSpecies_id = 70 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3045 | 261353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5990864 | 2091394 | 37.7220442755547 | -122.473688749933 | (37.7220442755547, -122.473688749933) | 9 | 8 | 4 | 64 | 40 | ||||
3768 | 262321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990975 | 2093805 | 37.7286707085155 | -122.473480827138 | (37.7286707085155, -122.473480827138) | 9 | 8 | 4 | 64 | 40 | ||||
4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
9246 | 254278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9702 | 254280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9745 | 175056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989706.76868 | 2089771.19579 | 37.7175213699925 | -122.477570413242 | (37.7175213699925, -122.477570413242) | 1 | 8 | 4 | 64 | 14 | |||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
13081 | 203859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991237.16543 | 2090216.16791 | 37.7188318441037 | -122.472313003552 | (37.7188318441037, -122.472313003552) | 9 | 8 | 6 | 64 | 24 | |||
16567 | 175055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.7174923263774 | -122.477830757993 | (37.7174923263774, -122.477830757993) | 1 | 8 | 4 | 64 | 14 | |||
18026 | 175051 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991233.90488 | 2088989.0818 | 37.7154623775575 | -122.472234874046 | (37.7154623775575, -122.472234874046) | 1 | 8 | 4 | 64 | 14 | |||
19477 | 203874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5993391.13026 | 2089210.06391 | 37.7161937512299 | -122.464794638879 | (37.7161937512299, -122.464794638879) | 9 | 8 | 6 | 64 | 24 | |||
20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
23392 | 203897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | 9 | 8 | 4 | 64 | 40 | |||
26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
28555 | 112249 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X EUCALYPTUS DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991186 | 2094598 | 37.730860304248 | -122.472809193365 | (37.730860304248, -122.472809193365) | 9 | 8 | 4 | 64 | 40 | ||||
29531 | 11850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
30315 | 114947 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 146 STRATFORD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990875 | 2091468 | 37.7222480982686 | -122.473656121456 | (37.7222480982686, -122.473656121456) | 9 | 8 | 4 | 64 | 40 | ||||
31813 | 203888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5990956.3868 | 2094658.3857 | 37.7310128131833 | -122.473607398684 | (37.7310128131833, -122.473607398684) | 9 | 8 | 4 | 64 | 40 | |||
32815 | 253627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 5991061 | 2093828 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | 9 | 8 | 4 | 64 | 40 | ||||
41158 | 175050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991220.94101 | 2089033.65994 | 37.7155840279702 | -122.472282930219 | (37.7155840279702, -122.472282930219) | 1 | 8 | 4 | 64 | 14 | |||
41461 | 203906 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990638.47075 | 2093500.44016 | 37.727814969685 | -122.47462199853 | (37.727814969685, -122.47462199853) | 9 | 8 | 4 | 64 | 40 | |||
42797 | 203857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991224.82027 | 2090017.23176 | 37.7182848998132 | -122.472341181102 | (37.7182848998132, -122.472341181102) | 9 | 8 | 6 | 64 | 24 | |||
44421 | 113145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
45252 | 256859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991007 | 2092571 | 37.7252843060575 | -122.473280239218 | (37.7252843060575, -122.473280239218) | 9 | 8 | 4 | 64 | 40 | ||||
46279 | 254187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 128 Stonecrest Dr | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990776 | 2093635 | 37.7281924051657 | -122.474156376051 | (37.7281924051657, -122.474156376051) | 9 | 8 | 4 | 64 | 40 | |||||
46991 | 203881 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 17 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 5991366.80632 | 2095895.31779 | 37.7344328773807 | -122.472278656638 | (37.7344328773807, -122.472278656638) | 1 | 8 | 4 | 64 | 40 | |||
48049 | 175052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991243.24078 | 2088948.27208 | 37.715350864326 | -122.472199632304 | (37.715350864326, -122.472199632304) | 1 | 8 | 4 | 64 | 14 | |||
48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
48779 | 203876 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | 9 | 8 | 6 | 64 | 24 | ||||
48793 | 294 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
54547 | 105345 | - 12 | Acacia melanoxylon :: Blackwood Acacia 70 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | |||||
55364 | 11774 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 2x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
56494 | 254186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990762 | 2093642 | 37.7282108143844 | -122.474205284655 | (37.7282108143844, -122.474205284655) | 9 | 8 | 4 | 64 | 40 | ||||
57299 | 203860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | 9 | 8 | 6 | 64 | 24 | |||
60433 | 203901 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 12 | Width 3ft | 5990470.12167 | 2090714.31084 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | 9 | 8 | 4 | 64 | 40 | |||
63078 | 396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | 9 | 8 | 4 | 64 | 40 | |||
63323 | 382 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
63360 | 203898 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5990605.80648 | 2090479.00693 | 37.7195169745995 | -122.474514509734 | (37.7195169745995, -122.474514509734) | 9 | 8 | 4 | 64 | 40 | |||
66284 | 203884 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 181 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5990872.1544 | 2094661.20304 | 37.7310156703418 | -122.473898806879 | (37.7310156703418, -122.473898806879) | 9 | 8 | 4 | 64 | 40 | |||
71099 | 203882 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 16 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 5991371.09776 | 2095893.61129 | 37.7344284401265 | -122.47226369551 | (37.7344284401265, -122.47226369551) | 1 | 8 | 4 | 64 | 40 | |||
71845 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 443X ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988110 | 2090275 | 37.7188118998372 | -122.483126550771 | (37.7188118998372, -122.483126550771) | 1 | 8 | 4 | 64 | 14 | ||||
72442 | 203880 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 18 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5991364.83676 | 2095904.51613 | 37.7344580197106 | -122.472286136294 | (37.7344580197106, -122.472286136294) | 1 | 8 | 4 | 64 | 40 | |||
73336 | 256346 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
75951 | 203899 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990601.43491 | 2090484.56274 | 37.7195319761887 | -122.474530025745 | (37.7195319761887, -122.474530025745) | 9 | 8 | 4 | 64 | 40 | |||
76918 | 11791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
83487 | 11823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
83959 | 255873 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990871 | 2092383 | 37.7247602290732 | -122.473736664855 | (37.7247602290732, -122.473736664855) | 9 | 8 | 4 | 64 | 40 | ||||
85020 | 217845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 35 | Front Yard : Yard | Tree | Private 2 | 24 | 5991433.42379 | 2095847.21705 | 37.7343046601167 | -122.4720448356 | (37.7343046601167, -122.4720448356) | 1 | 8 | 4 | 64 | 40 | ||||
87061 | 104723 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.7174475379801 | -122.477917527277 | (37.7174475379801, -122.477917527277) | 1 | 8 | 4 | 64 | 14 | ||||
91558 | 203887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 179 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5990924.31615 | 2094659.11816 | 37.7310129669604 | -122.47371832465 | (37.7310129669604, -122.47371832465) | 9 | 8 | 4 | 64 | 40 | |||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
96578 | 358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | |||
96699 | 11795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | ||||
97511 | 203879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 19 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 5991366.58351 | 2095910.40405 | 37.7344742875433 | -122.472280526329 | (37.7344742875433, -122.472280526329) | 1 | 8 | 4 | 64 | 40 | |||
97637 | 203891 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 173 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 5991044.7899 | 2094655.13381 | 37.7310090036421 | -122.473301540158 | (37.7310090036421, -122.473301540158) | 9 | 8 | 4 | 64 | 40 | |||
100294 | 11789 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
102740 | 203893 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 Eucalyptus Dr | 2 | : | Tree | Private 2 | 5 | Width 2ft | 5991106.51635 | 2094658.68815 | 37.7310223370083 | -122.473088402602 | (37.7310223370083, -122.473088402602) | 9 | 8 | 4 | 64 | 40 | |||
104965 | 258052 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 856 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x6 | 5991236 | 2091663 | 37.7228044207006 | -122.472422451465 | (37.7228044207006, -122.472422451465) | 9 | 8 | 4 | 64 | 40 | ||||
106101 | 107308 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 190 EUCALYPTUS DR | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | 1 | 8 | 4 | 64 | 40 | ||||
108347 | 203877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 6 | Back Yard : Yard | Tree | Private 2 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | 9 | 8 | 6 | 64 | 24 | ||||
111808 | 203861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991252.63127 | 2090414.41238 | 37.7193770697644 | -122.472273988268 | (37.7193770697644, -122.472273988268) | 9 | 8 | 6 | 64 | 24 | |||
112768 | 11794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
113579 | 203904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357 | (37.7272777533559, -122.47464379357) | 9 | 8 | 4 | 64 | 40 | |||
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
117611 | 104976 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | 9 | 8 | 4 | 64 | 40 | |||
119294 | 203878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 20 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 5991362.95772 | 2095918.02159 | 37.7344949935417 | -122.472293616873 | (37.7344949935417, -122.472293616873) | 1 | 8 | 4 | 64 | 40 | |||
120769 | 115677 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | 1 | 8 | 4 | 64 | 14 | ||||
121507 | 256861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 372 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991087 | 2092598 | 37.7253630733191 | -122.473005657757 | (37.7253630733191, -122.473005657757) | 9 | 8 | 4 | 64 | 40 | ||||
123363 | 203890 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5991011.74416 | 2094657.21816 | 37.7310128131914 | -122.473415935702 | (37.7310128131914, -122.473415935702) | 9 | 8 | 4 | 64 | 40 | |||
128901 | 256427 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3001 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
130062 | 256429 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3001 Sunset Blvd | 17 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
132363 | 203892 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 173 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5991062.18306 | 2094654.07331 | 37.7310070989021 | -122.473241332345 | (37.7310070989021, -122.473241332345) | 9 | 8 | 4 | 64 | 40 | |||
132427 | 106774 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 155X Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990905.03002 | 2094685.30674 | 37.7310837571916 | -122.473786909188 | (37.7310837571916, -122.473786909188) | 1 | 8 | 4 | 64 | 40 | |||
133418 | 29972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.472207797253 | (37.7284219643784, -122.472207797253) | 9 | 8 | 4 | 64 | 40 | ||
133684 | 114109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | ||||
134245 | 11817 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
135252 | 254189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 187x Stonecrest Dr | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5990830 | 2093201 | 37.7270038779971 | -122.473938047356 | (37.7270038779971, -122.473938047356) | 9 | 8 | 4 | 64 | 40 | |||||
135909 | 11755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X4 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
138449 | 203900 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 2ft | 5990599.12007 | 2090493.05504 | 37.7195551598198 | -122.474538646659 | (37.7195551598198, -122.474538646659) | 9 | 8 | 4 | 64 | 40 | |||
143891 | 175053 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 3ft | 5991263.57125 | 2088857.38752 | 37.7151024940541 | -122.472122741173 | (37.7151024940541, -122.472122741173) | 1 | 8 | 4 | 64 | 14 | |||
145746 | 11787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
146757 | 203883 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 181 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5990856.83561 | 2094661.52619 | 37.7310156703238 | -122.473951789565 | (37.7310156703238, -122.473951789565) | 9 | 8 | 4 | 64 | 40 | |||
148931 | 203885 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 181 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5990886.77711 | 2094660.89457 | 37.7310156703264 | -122.473848231707 | (37.7310156703264, -122.473848231707) | 9 | 8 | 4 | 64 | 40 | |||
149110 | 203889 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 5990973.09851 | 2094658.03322 | 37.7310128131802 | -122.47354959835 | (37.7310128131802, -122.47354959835) | 9 | 8 | 4 | 64 | 40 | |||
152684 | 217836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 26 | Front Yard : Yard | Tree | Private 2 | 15 | 5991394.92255 | 2095812.43356 | 37.7342069253901 | -122.472175410894 | (37.7342069253901, -122.472175410894) | 1 | 8 | 4 | 64 | 40 | ||||
152891 | 11815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
152984 | 11820 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
154920 | 256347 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Sunset Blvd | 26 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
154984 | 175054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5989611.995 | 2089764.54456 | 37.717497607213 | -122.477897512877 | (37.717497607213, -122.477897512877) | 1 | 8 | 4 | 64 | 14 | |||
155850 | 217844 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 34 | Front Yard : Yard | Tree | Private 2 | 13 | 5991434.00834 | 2095858.95759 | 37.7343369305015 | -122.472043670098 | (37.7343369305015, -122.472043670098) | 1 | 8 | 4 | 64 | 40 | ||||
156355 | 36261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256484 | 37.7307369236006 | -122.472799488507 | (37.7307369236006, -122.472799488507) | 9 | 8 | 4 | 64 | 40 | ||
156844 | 203862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 951 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5991278.5837 | 2090872.19555 | 37.7206355315929 | -122.472217633157 | (37.7206355315929, -122.472217633157) | 9 | 8 | 6 | 64 | 24 | |||
157976 | 203886 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 179 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 5990904.52602 | 2094659.81663 | 37.7310137385845 | -122.473786792727 | (37.7310137385845, -122.473786792727) | 9 | 8 | 4 | 64 | 40 | |||
160184 | 11793 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
162539 | 203875 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | 9 | 8 | 6 | 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) );